Give it a try with the HTML notation € - even though that you are generating Excel output, in fact it is a HTML code that Excel imports as a valid spreadsheet.
Thanks for your reply..
As a bi publisher beginner, Sorry I didnt get your reply
In the Template word BI publisher properties I used
Both worked fine..
But for EUR
is not working
what could be the reason for not getting euro.