View Single Post
  #2  
Old May 31st, 2010, 01:17 PM posted to microsoft.public.excel.newusers
Sheeloo
external usenet poster
 
Posts: 797
Default excel 2007 csv gibberish

How are you saving the CSV file? Did it work in Excel 2003?

While saving as CSV pick 'Unicode Text (.txt)" option and see whether it
solves the problem.

Normally text files (CSV) contain English characters only (ASCII chars upto
127). Hebrew Characters are beyond 127... so you need to save in Unicode.

"Fran" wrote:

I'm using Office 2007 English. When I open a previously saved csv file that
was saved containing Hebrew text, it opens as gibberish. When I open saved
Excel file that is Hebrew it opens correctly. Why would cause this to happen
suddenly?

.