I am using excel for mac 2011 and have already changed the settings in the mac excel 2011 language register settings to allow Chinese Simplified and Japanese languages but when i open an excel/csv file with chinese/Japanese characters it shows weird characters. It looks like this:
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
Have also changed the font to arial unicode MS but to no avail.
CAPSULE_TEXT | GENRE_NAME | PRICE_RATE | CATALOG_PRICE |
�般ƒ�ƒ��般ƒ�ƒ�52 | 5659 | 2690 | 6/26/12 12:00 |
�般ƒ�ƒ��般ƒ�ƒ�52 | 18000 | 8500 | 6/27/12 12:00 |
�般ƒ�ƒ��般ƒ�ƒ�51 | 7200 | 3480 | 6/28/12 12:00 |
�般ƒ�ƒ��般ƒ�ƒ�50 | 3300 | 1650 | 6/24/12 12:00 |
�般ƒ�ƒ��般ƒ�ƒ�56 | 3650 | 1600 | 6/26/12 12:00 |
�般ƒ�ƒ��般ƒ�ƒ�50 | 12600 | 6300 | 6/28/12 12:00 |
�般ƒ�ƒ��般ƒ�ƒ�51 | 11300 | 5480 | 6/26/12 12:00 |
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
Have also changed the font to arial unicode MS but to no avail.