Percentage and/or chinese character problem in using mail merge.

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.

Thanks for your prompt reply Lemice.
I have been away for the past week, so this is the first chance Iv had to login.
I will give you suggestion a try and let you know the outcome.
Thanks again.

Originally Posted by Lemice

Hello,

You might have to "convert" the value into another value first, e.g. converting your 0.965891273891273981273 into 96.0 by formula like this

Please Login or Register  to view this content.

Assuming that number is in Cell A1. I guess when you force it to be another value like that, it won't have trouble displaying in other application.

Hi Lemice.

Excuse me Im a bit of an amature on excel. COuld you please advice me step by step what to do with this code. I presume I should copy the formula into the cells that contains the percentages, right?
For example I have the percentages in the spread sheet in cells K2 - 8. However, when I add the code it displays #VALUE!.

Please can you advise.

Thanks