How to merge monetary values from Excel to Word?

[DSmithWBP]

I am trying to merge an excel worksheet to Word, but when I merge the
information, such as dollar amounts, i.e. 103,801,186, I lose the commas and
I have to go into each merge letter in Word and insert the commas. Or if I'm
using a % amount, it shows up on Word as a long decimal. Is there a way to
set this up in Excel so it will merge in true format? Any help would be
greatly appreciated.
Thanks!!

 

[Bob Greenblatt]

I am trying to merge an excel worksheet to Word, but when I merge the
information, such as dollar amounts, i.e. 103,801,186, I lose the commas and
I have to go into each merge letter in Word and insert the commas. Or if I'm
using a % amount, it shows up on Word as a long decimal. Is there a way to
set this up in Excel so it will merge in true format? Any help would be
greatly appreciated.
Thanks!!

The problem is with Word, not Excel. Look in word help for "format merged
Data". You will need to add switches to the merge field to format the data.

 

[jpdphd]

I am trying to merge an excel worksheet to Word, but when I merge the
information, such as dollar amounts, i.e. 103,801,186, I lose the commas and
I have to go into each merge letter in Word and insert the commas. Or if I'm
using a % amount, it shows up on Word as a long decimal. Is there a way to
set this up in Excel so it will merge in true format? Any help would be
greatly appreciated.
Thanks!!

I just tried it and had no problem. Then, I changed the formats in
Excel, saved the changes and tried again in Word. The changes were NOT
reflected in the merged document. After some trial and error, I found
that I had to close and re-open the data source with the Word Data
Merge manager before changes in formatting were recognized.
You might try this as well.
jpdphd

 

[macropod]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at
http://www.gmayor.com/formatting_word_fields.htm

Cheers