View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Bond Michael Bond is offline
external usenet poster
 
Posts: 3
Default Saving double-byte characters as unicode text in a CSV file

I'm having a problem doing something I have done successfully before. I need
to save some double-byte characters that I see in an Excel file into a
comma-delimited CSV file. Sounds simple, but I'm not getting the results I
need.

Here's what I'm doing with the file in Excel 2007.

1. Save As
2. Other Formats
3. CSV (MS-DOS) (*.CSV)
4. Open the file in Wordpad or Notepad

Unfortunately, a cell that looks like this in Excel: 什么是情商?

turns into this in the CSV file: ????????????

Any suggestions?

Thanks in advance for your help!
--
Michael