Lose your Currency Format When You Mail Merge from Excel to Word?

Turn your field codes on: Press ALT + F9 to do this…

It goes from this appearance:

Before:clip_image002After:clip_image004

Then your fields will not have the formatting that you see in my display you will need to add it.

You will add this code inside the merge field to format it to look like money:

# "$,0.00;($,0.00)"

For more information visit this article:

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

About the author: Robin E. Hunt