Hi,
I have an ASP form that displays currencies like Euro and Sterling. I have a button that will export the data to excel (button code looks something like this):
Response.Clear
Response.ContentType = "application/vnd.ms-excel; charset=utf-8"
Response.AddHeader "Content-Disposition", "attachment; filename=report.xls"
Response.Write "<html xmlns:x=""urn:schemas-microsoft-com:office:excel"">"
Response.Write "<!--[if gte mso 9]><xml>"
Response.Write "<x:ExcelWorkbook>"
...
Response.Write "</html>"
The problem is that when the excel file is created, the Euro displays as "€". I can't figure out why? Can anyone help?
Many thanks in advance!
Mark
Go to the complete details ...