maintaining Excel formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KAN - 13 Nov 2003 15:56 GMT

I am merging data from an Excel spreadsheet into Word. The formatting of the numbers is being changed. For example, in Excel I have the numbers formatted as 'number' with no decimal places. In the merged Word document, the numbers convert to 6 decimal places. How can I keep the Excel formatting? Thanks!!

Reply to this Message

BS - 13 Nov 2003 17:11 GMT

Hi KAN;

first way is to format all data in excel as text. But i think this is not a
proffessional way. So to format your field try this below:

{ MERGEFIELD NUMBER } ----> { MERGEFIELD NUMBER \# "0" }

i did not try this yet. But i think this will fix.

Reply to this Message