Mail Merge to Microsoft Word

[Laurie]

I have a user who is trying to use mail merge to merge
financial data in Excel into a Microsoft Word document.
The data is formatted for currency in Excel but when she
merges it into Word, it comes out as plain numbers with
many decimal places after it.

How do I get this data to hold it's currency formatting
when merging into Word?

Thank you very much!

 

[PegL]

I gather you're using XP. This is a new "feature" in mail
merge in XP. To resolve it, in the mergefield in Word,
add a numeric field switch. You'll need to toggle the
field code for the field to change this. Depending on
what you want to see, the format is something like
{MERGEFIELD X \# #,##0.00 }.

 

[JE McGimpsey]

You can't merge formatting unless you convert your XL data to Text, but
you can add format switches to your merge fields. See Cindy Meister's
mail merge FAQ:

http://homepage.swissonline.ch/cindymeister/mergfaq.htm