Maintaining Formats when Merging from Excel to Word

[Mari]

Hi all,

I am trying to merge information into form letters that I
have created in Word. One of the fields is a dollar
amount that is formatted in Excel to show the dollar sign
and commas. When I merge it into the word docs, the
formatting disappears and I am left with a plain number
with no dollar sign and no commas.

Is there any way to keep the formatting that I have in
Excel when I merge the documents?

Thanks in Advance!

Mari

[Debra Dalgleish]

You could try adding a formatting switch to the Word merge field.

1. In the Word document which contains the merge fields, press Alt+F9 to
reveal the codes.
2. In the total amount field, add a formatting switch, similar to this
example:

Original field: {MERGEFIELD Amt}
With switch: {MERGEFIELD Amt \# "$#,##0.00;($#,##0.00)"}

3. Press Alt+F9 to hide the codes.

Mari wrote:
> Is there any way to keep the formatting that I have in
> Excel when I merge the documents?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html