excel 2007 csv gibberish

  • Thread starter Thread starter Fran
  • Start date Start date
F

Fran

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?
 
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.
 
Back
Top