View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default tsv file open in turkish font and it should be hebrew why ?

I believe that the .tsv is equivalent to the english file CSV (comma
seperated values). If you remane the file as TXT and open the file a pop up
window will appear that has the option to start at row 2 instead of row 1.
This may solve your problem.

"Shally" wrote:

when i export text file from my erp that contain hebrew fonts the file is
saved as *.tsv file.
when i open it in the excel it open every time with gibrish.
if i open it manually and using the text import wizard i can see that the
file origin font is set to Turkish(Windows), if i change it to
Hebrew(Windows) it fix the font and the file open good.
i want to skip that part and make it open the file directly with
Hebrew(Windows), how to do that ?