Hi
Please can somebody help me.
After doing a mail merge with an excel spreadsheet as the source I’m encountering some problems.
I’m trying to merge English and Chinese characters, as well as, numbers and percentages in to a report on MSWord. The problems I am facing are, if I connect to the Excel spreadsheet by “Excel Via ODBC”, then all the percentages display perfectly. However, the Chinese characters are displayed as "???".
Alternatively if I connect by the "OLE DB Database files" method, then the Chinese characters display correctly. Although the percentages are not displayed correctly. See below:
0.96499999999999997 Instead of 96.0

3.7999999999999998 Rather than 3.7

This problem has been driving me crazy. I hope someone can help me.
If anyone can advise me on how to get Chinese characters to display correctly using Excel via ODBC or alternatively advice me on how to fix the percentage display problem. I have read posts on how to limit the number of decimal places. However I don’t know how to change them from 0.96 to 96.0.
Alternatively if anybody has any other suggestions on how to solve my problem please share your ideas with me.

Thanks in advance.