Currency

[Craig Pfaff]

I'm trying to mail merge from Excel to Word and in the data source my money
fields
have dollar signs and commas, but when I merge it through it loses those
properties.
So therefore $100,000 comes out looking like 100000. I'm using Word 2002 and
Excel
2002 with the OS being W2K Pro. I've tried everything I can think of any
suggestions would
be appreciated.

Thanks Craig

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Craig Pfaff]

Thanks Graham, I was just wondering if we have any other options?
Maybe on Excel side?

 

[Graham Mayor]

This is the simplest way to do it. The alternative is as detailed in the
Excel Data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>