![]() |
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? |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com