Codepages and displaying euro sign
 

We are outputting a CSV file from a .Net (C#) application and it is writing
the euro currency sign (‚¬), we are using the default encoding for the
StreamWriter class which is UTF-8 (65001).

When the file is viewed in notepad, it displays the character correctly but
in MS Excel 2003 (XP SP2) the character is translated to '‚¬'.. We can
resolve the issue by specifiying the windows 1252 codpage when generating the
file, but we are wondering if this is the correct approach or it there a more
suitable solution?

Also what is the codepage used for MS Excel 2003? - is this dependant on the
OS Locale at all.

Cheers

Ollie Riches