Question Locked

Mail merge Excel figures into Word docs - keeping two decimal places

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When mail merging $ figures from an Excel spreadsheet into a Word based mail merge, I find that sometimes my dollar figures change from two decimal places on the spreadsheet to about 15 decimal places in Word. How do I ensure that that the figures in my spreadsheet are duplicated correctly in my Word merge? Thanks.

5 replies

by amandamaomao

Are you still bothered by the annoying job of merging multi-worksheet excel files into one worksheet? You may have to merge excel files into one new sheet or merge excel workbooks into one new workbook, then Merge Excel Files software is your right choice in simplifying your tedious merging work.You can download a free useful software on:http://www.merge-excel-files.com/

by sccaatom2

The formatting is lost when you bring the field over from Excel. Insert your field in Word then use Alt + F9 to reveal the merge code . It will look like {Mergefield Cost} Left click after the name of the field(in this example cost) and before the right brace. Put a backslash and then a quotation mark, then a dollar sign, Then a pound sign followed by a period followed by two more pound signs and end the quotation mark. It should look like this: {Mergefield Cost\"$#.##"} Then use Alt + F9 again to return to the document. Preview your merge and you should be finished. You may have to go forward one record and then back to force it onto the current merge record That should end your problem. The same thing happens when you merge from Access into Word.

by Wizard57M-TR

After 2 & 1/2 years, the OP probably gave up. So, instead of waking a
zombie, make a new topic in the Discussions area!

This discussion is closed to new replies.