maintaining Excel formatting

K

KAN

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!!
 
B

BS

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.
 
Top