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.
 

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

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Help!!!!! 2
Excell 2021 0
Add csv to Open "All Excel Files" (XL2007) 3
Excel CSV Files; Creating Of 3
.csv Commas ? 2
Sr. Citizen Needs Help, Please: WORD shows Nothing, But NotepadShows "Gibberish" ? 3
import file so that it is a actual csv file, no excel cell version 1

Back
Top