excel 2007 csv gibberish

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?
 
S

Sheeloo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top