Ask a new question

extra decimal points when trying to mail merge

I am trying to mail merge an existing document with a letter in word. Every time that I mail merge, some of my numbers end up with extra decimal points. I have triple checked that the cell is formatted only to two decimal places. I get two decimal places for everything but my last two numbers. I have also tried to use a different way to open up the excel file, such as Dynamic Data Exchange (DDE), but every time I try to do that, it says there is an error and I need to reestablish my DDE connection. I have tried rebooting, copy the document to a new one and other ways, but I cannot restore the connection. How can I try and restore that DDE connection or how can I end up with only two decimal places. Please help me.
Answer
Answer

I'd avoid DDE - it's ancient technology that is flaky nowadays.

It's best to format the numbers in Word.

Right-click the relevant merge field and select Toggle Field Codes from the context menu.

You'll see something like

{ MERGEFIELD MyField }

or

{ MERGEFIELD MyField \* MERGEFORMAT }

where MyField is the name of the mail merge field.

If you want 2 decimal places, make it look like this:

{ MERGEFIELD MyField \# "0.00" }

If you want 2 decimal places and comma as decimal separator, make it look like this:

{ MERGEFIELD MyField \# "#,0.00" }

Then press F9 to hide the field code and to update the result.

---
Best wishes, HansV
https://www.eileenslounge.com

156 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 14, 2024 Views 29,890 Applies to: