86
20
Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)?
I When I try to open a csv file encoded in Japanese SHIFT-JIS, it opens but with mojibake (corrupted characters). In Open Office Calc, if you click on a csv file with a non-standard encoding like SHIFT-JIS, it automatically opens a dialog where you can set the encoding.
Which version of Excel? – paulmorriss – 2011-05-09T09:26:02.107
2003 or 2010 (I skipped 2007) – lozzer – 2011-05-10T17:49:05.933