Mail Merge in Word 2010 with Excel 2010; field formatting lost in Word

Word does not have the round of function that is why  8.25% appears as  .082500000.\

 

Check the below article for Date, Phone Number, and Currency fields are merged incorrectly when you use an Access or Excel data source in Word.

 

http://support.microsoft.com/kb/304387

 

 

---

Ruchi Bisht

I am having similar difficulties.

 

I have direct number entries on a spreadsheet where the value is entered as ###.## - only two entries after the decimal, formatted the same. When I merge the information into Word, the Merge coding is adding more decimal places and numbers. For example, what is entered in Excel says 2.05, but if you look at the value in the Merge, it's 2.049999999997.

Anyone have any ideas on why this is happening? It takes me a long time to go back through the merge and correct the numbers that never should have been there in the first place.

 

Thanks!

Mail merge uses the data as it is STORED in Excel, not as it is displayed in Excel, which is controlled by the Excel cell formatting.

To format the output of mail merge, it is necessary to add a formatting switch to the mergefield in the mail merge main document (before executing the merge)

All of the information that you will need to do this is contained in the article "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

This did not work for me.  Either I am entering the field construction incorrect or something... PLEASE PLEASE HELP!!!!

I found that if you have the correct formatting in Excel, it actually comes into the document once you "finish and merge".  Prior to that, you will note specifically formatted fields will not mbe formatted.  Try it!  I was going nuts with a time format, but once I finally merged the document and said I wanted to edit individual letters, the time was formatted correctly. 

I found that if you have the correct formatting in Excel, it actually comes into the document once you "finish and merge".  Prior to that, you will note specifically formatted fields will not mbe formatted.  Try it!  I was going nuts with a time format, but once I finally merged the document and said I wanted to edit individual letters, the time was formatted correctly. 

You may just have been lucky as Excel does NOT store its data in the way that it is displayed by the cell formatting.  Or, you may have been linking to the file using the out-dated DDE method.

Hi Doug,

    I have tried and read your recommendations and it makes logical sense.  However, when I put it into the field code as follows, it says that there is a syntax error:

 

={MERGEFIELD [Name of Merge Field] }*100} \# "##%" }

 

Another thing is when I go to edit the field code, it changes it to be the following:

 

={MERGEFIELD [Name of Merge Field] }*100} \# "##%" } \* MERGEFORMAT

 

Can you please help with the syntax?  Last thing to note is that when I try to put in the curly paranthesis before the =, it doesn't allow me to click "OK" to accept.  Thanks so much for your help!