Mail Merge

  • Thread starter Thread starter Assistant
  • Start date Start date
A

Assistant

I am having a problem with my mail merge, If I type in my
Excel cell 15.67, In the mail merge, it comes across as
15.6700000000000001. This has recently started happening,
it worked fine before. Does anyone have any insights?
 
In the Mail Merge, 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
 
THANK YOU!
-----Original Message-----
In the Mail Merge, 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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Click to expand...
 
Back
Top