Caporegime
- Joined
- 13 May 2003
- Posts
- 34,559
- Location
- Warwickshire
Hello
I'm downloading transactions from my accounting system (Sage 50) into Excel (2007).
Any Euro symbols show correctly as € in the CSV file, but display as € in Excel.
Has anyone come across this before or know of a way around the problem (aside from find and replace)? The only thing I could think to try so far is changing the cell from general to text format; it didn't work.
Many thanks.
I'm downloading transactions from my accounting system (Sage 50) into Excel (2007).
Any Euro symbols show correctly as € in the CSV file, but display as € in Excel.
Has anyone come across this before or know of a way around the problem (aside from find and replace)? The only thing I could think to try so far is changing the cell from general to text format; it didn't work.
Many thanks.