maintaining Excel formatting

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

 

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