merging values to word - formatting does not stay

  • Thread starter Thread starter Jennifer Howard
  • Start date Start date
J

Jennifer Howard

i am merging numbers to word documents and the formatting
will not stay. e.g. 45698723.2365879 is what shows up in
my merge, however in excel i have formatted it so it
appears as $45,698,723.24

can anyone help on this issue?
 
Jennifer

Just because you have formatted the number one way does not change what is
actually in the cell. The mail merge will just take the value from the cell,
regardless of the formatting.
You need to use a helper column with =ROUND(A2) in it, and then Copy / Paste
Special / Values to fix the result.

Andy.
 
After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you connect through a different source, you can format the fields in
the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with zero decimal places.
For example:
{ MERGEFIELD FieldName \# "$#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
Back
Top