Excel 2003 and Unicode csv files

M

MarkR

I open Notepad, paste in "Zürich" (notice the accent on the u), File, Save As
test1.csv, change the encoding to Unicode and hit save. When I open that
file (by double-clicking it), Excel opens the file and it looks fine.

I open Notepad, paste in "Zürich" (notice the accent on the u), File, Save
As test2.csv, change the encoding to UTF-8 and hit save. When I open that
file (by double-clicking it), Excel opens the file and the accented u is
changed by Excel.

I am using Excel 2003 running on XP.

Anyone know if there is a way to open the UTF-8 file without that happening?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
Excel And Notepad 3
How can I make Excel save Unicode CSV data correctly? 0
Unicode in CSV files 5
Unicode text and carriage returns 4
open UTF8 CSV 0
["\r\n" new line command in CSV file] 1
Saving double-byte characters as unicode text in a CSV file 4

Top