| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 and Unicode csv files
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
| why can unicode and alt+x not work on my excel | Excel Discussion (Misc queries) | |||
| opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
| converter tool to convert XL 2007 files to XL 2003 files | Excel Discussion (Misc queries) | |||
| Excel ignores "Text qualifiers" in Unicode files | Excel Discussion (Misc queries) | |||
Threaded Mode
