MailMerge loosing format from XL/Xp DS

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

I am trying to run a mail merge using an excel Data Source. The data in the
amount column is typed in, and is formatted as currency. when the mail merge
is performed my data is changed from $300.26 to 300.259999999 on the letter.
I have tried to format the data column with anything that accepts a decimal;
and receive the same results.

Can you help?

I am running everything on the xp office disk, and service pack 2
 
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 two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
Back
Top