Unable to read Simplified Chinese in downloaded excel

[Former Member]

Hi,

We are running an MDMP Simplified Chinese SAP system.

After extracting some data with both English and Simplified Chinese and saving it as excel file, we are not able to view the Simplified Chinese characters when it is opened in MS Excel. "Garbage" are being displayed in place of Simplified Chinese. English display is ok.

The PC already has Simplified Chinese fonts installed (Control Panel->Regional & Language Options->Language tab->Install files for East Asian languages), and Windows XP is an English version.

In addition, we are able to key in Simplified Chinese via the keyboard using Hanyu Pinyin.

I am suspecting that the issue is with MS Excel which doesn't know how to convert the Simplified Chinese.

Does anyone know how to overcome this problem?

Thanks

[nils_buerckel · Accepted solution]

Hi,

as far as I know you need to set the system locale (Language for Non-Unicode programs) of Windows in the control panel to Chinese.

In addition in a standard MDMP system it is mandatory to logon with language Chinese if you want to download Kanji characters.

Best regards,

Nils Buerckel

[Former Member · Accepted solution]

Thanks, Nils for the reply.