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

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Craig Pfaff wrote:
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

Thanks Graham, I was just wondering if we have any other options?
Maybe on Excel side?
"Graham Mayor" wrote in message
...
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Craig Pfaff wrote:
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

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_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Craig Pfaff wrote:
Thanks Graham, I was just wondering if we have any other options?
Maybe on Excel side?
"Graham Mayor" wrote in message
...
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Craig Pfaff wrote:
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