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

By 5foot1 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Overcome Excel to Word mailmerge number format problems

by Peconet Tietokoneet In reply to Mail merge Excel figures ...
Collapse -

How to merge excel files into one

by amandamaomao In reply to Mail merge Excel figures ...

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:

Collapse -

Here is the solution

by sccaatom2 In reply to Mail merge Excel figures ...

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.

Collapse -

Reponse To Answer

by wizard57m-cnet Moderator In reply to Here is the solution

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

Related Discussions

Related Forums