#1
|
|||
|
|||
Formatting numbers in a mail merge
Mail merging from Excel to Word, the number format from Excel should be to 2 decimal places but in the mail-merge document the format adds numerous zeros to the number. How do I format the merge to give me only 2 decimal places? |
#2
|
||||
|
||||
See Mailmerge Number & Currency Formatting in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Mail-merge help
Hi Macropod,
The actual figure in the Word Document after the merge is 26.800000000000001 (13 zeros) I have tried the tips you suggested but I must not be understanding what I am trying to do, as the result does not change. The only thing I didn't try is to make the change and save/close the document and try again, would that help?? Andy |
#4
|
||||
|
||||
Did you re-run the merge after updating the field in the mailmerge main document?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Mail Merge
Hi Paul, Sorry for the delay in replying. Tried to open the file this morning to test your fix and got a message to tell me that the Excel file is now corrupt and can't be opened!!!
I am currently going through the various MS fixes?? Will let you know hoe I get on. Cheers, Andy |
#6
|
|||
|
|||
Mail Merge
Hi Again,
Just to let you know that after fixing the problem with not being able to open the mail merge file, I can tell you that your fix did work. I now have a working mail merge file giving me the details I wanted. Cheers, Andy |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Formatting Issue with Conditional IFs | robbeh | Mail Merge | 5 | 07-08-2014 07:39 AM |
Mail Merge Formatting Phone numbers | Marie_Melody | Mail Merge | 4 | 07-02-2014 04:22 PM |
Formatting changes after mail merge | staceynairn | Mail Merge | 1 | 06-03-2014 06:29 PM |
Formatting in mail merge document | OnTheCouch | Mail Merge | 1 | 09-29-2013 07:05 PM |
Continuous page numbers with mail merge? | Jennifer Murphy | Mail Merge | 1 | 08-11-2011 05:27 AM |