Mail Merge

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

 

[Peo Sjoblom]

You could temporarily use tools>calculations and select precision as
displayed

 

[Debra Dalgleish]

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

 

[Guest]

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

.