Mail Merge (2003)

Topic

New Reply

I’m ready to pull my hair out over this. I have a column in my Excel spreadsheet named Daily Interest. In the field it displays the interest like so…

0.28

When I click on the field it displays up in the bar like so 0.27995. Then I perform a mail merge in Word, and it displays like so…
0.27995000000000003

I’ve formatted the darn field a 100 times trying to get it to carry over just as 0.28. I can’t get it right. Any suggestions. It should display as 0.28 no matter where I see it.

Reply | Quote

Replies

Quick question:

Does the field contain a value or is it a formula?

If it contains a formula, try wrapping it with a ROUND() function.

=ROUND(MyOtherFormula,2)

Reply | Quote

You can format the field in Word:
– Right-click the mail merge field Daily Interest.
– Select Toggle Field Codes from the popup menu.
– You’ll see something like this:

{ MERGEFIELD “Daily Interest” }

– Add a formatting switch to make it look like this:

{ MERGEFIELD “Daily Interest” # “0.00” }

– Press F9 to hide the field code and to update the field.

PS You haven’t provided feedback on the questions you asked in the Access forum recently. As a consequence, other Loungers reading those threads don’t know if the replies were helpful.

Reply | Quote