There are two ways to approach this. In a mail merge, you can add a numeric
picture switch to the merge field. Or you can connect to Excel via DDE
instead of OLEDB. For more on both, see
http://homepage.swissonline.ch/cindy...002/MM2002.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Doreen" wrote in message
...
Word and Excel 2002

I'm importing from Excel to Word.

When I import what looks like $12,000 in Excel, it becomes 12000 in Word.
I
understand that's because the data is 12000 and in Excel I've formatted it
with Currency and Comma styles.

My question is, what's the easiest way to get $12,000 in Word without
having
to manually fix each entry?

Thanks in advance.

Doreen