Maintaining currency formatting in a Mail Merge?

[Martinson44]

How do I maintain (or permanently convert to text) formatted cells from Excel
when using it with a Mail Merge in Word?

 

[David Biddulph]

Look at the TEXT function. You'll find details in Excel help.

 

[Dave Peterson]

You can also format the values when you do the mail merge.

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.