how to view chinese/japanese characters in excel?

[jennxf]

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:

[TABLE="width: 260"]
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"]CAPSULE_TEXT[/TD]
[TD="width: 65"] GENRE_NAME [/TD]
[TD="width: 65"]PRICE_RATE [/TD]
[TD="width: 65"]CATALOG_PRICE[/TD]
[/TR]
[TR]
[TD="class: xl64"]�般&#131;�&#131;��般&#131;�&#131;�52[/TD]
[TD="align: right"]5659[/TD]
[TD="align: right"]2690[/TD]
[TD="class: xl63, align: right"]6/26/12 12:00[/TD]
[/TR]
[TR]
[TD]�般&#131;�&#131;��般&#131;�&#131;�52[/TD]
[TD="align: right"]18000[/TD]
[TD="align: right"]8500[/TD]
[TD="class: xl63, align: right"]6/27/12 12:00[/TD]
[/TR]
[TR]
[TD]�般&#131;�&#131;��般&#131;�&#131;�51[/TD]
[TD="align: right"]7200[/TD]
[TD="align: right"]3480[/TD]
[TD="class: xl63, align: right"]6/28/12 12:00[/TD]
[/TR]
[TR]
[TD]�般&#131;�&#131;��般&#131;�&#131;�50[/TD]
[TD="align: right"]3300[/TD]
[TD="align: right"]1650[/TD]
[TD="class: xl63, align: right"]6/24/12 12:00[/TD]
[/TR]
[TR]
[TD]�般&#131;�&#131;��般&#131;�&#131;�56[/TD]
[TD="align: right"]3650[/TD]
[TD="align: right"]1600[/TD]
[TD="class: xl63, align: right"]6/26/12 12:00[/TD]
[/TR]
[TR]
[TD]�般&#131;�&#131;��般&#131;�&#131;�50[/TD]
[TD="align: right"]12600[/TD]
[TD="align: right"]6300[/TD]
[TD="class: xl63, align: right"]6/28/12 12:00[/TD]
[/TR]
[TR]
[TD]�般&#131;�&#131;��般&#131;�&#131;�51[/TD]
[TD="align: right"]11300[/TD]
[TD="align: right"]5480[/TD]
[TD="class: xl63, align: right"]6/26/12 12:00[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


Have also changed the font to arial unicode MS but to no avail.