View Japanese Kanji in CSV file

P

PeterB

I have a CSV file that contains double-byte data but when I open it in Excel
2003 the data is not displayed as Kanji characters. I have tried using the
Get External Data wizard and selecting UTF-8 but that does not help. I have
tried this on a PC with the Japanese language pack installed and the Office
2003 Language Pack installed and it still does not work. I have proved the
file does contain the data by saving it as a web page from Excel, then
viewing it in IE and changing the browser encoding to Japanese - the data is
then displayed properly as Kanji.

Can anyone advise the correct way to display the data in Excel as Kanji? I
assume I'm missing something...

thanks

Peter
 

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

Sorting order of foreign languages 0
Japanese text entry broken 1
Japanese Hiragana Input returns Max Apple Symbol output 0
Adding data to MS Access from csv file 0
Outlook 2007 folders display in Japanese, can't get them into Engl 3
Update Kanji Char in SQL Database from Access returns question mar 0
Create a dynamic master file 1
Can I convert hiragana to Kanji, with a hiragana superscript readi 0

Top