[spatrsculp111]

I am trying to merge data points from excel into a letter in Word, and when I
do all the formatting in the excel file is lost. For example I am inserting
a cost and instead of $50.00 I get 50.00000. How do I fix this. It shows up
in excel the way I want.

[Suzanne S. Barnhill]

Either connect to Excel via DDE rather than OLEDB or use formatting
switches; see http://www.gmayor.com/formatting_word_fields.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.

"spatrsculp111" wrote in message
...
I am trying to merge data points from excel into a letter in Word, and
when I
do all the formatting in the excel file is lost. For example I am
inserting
a cost and instead of $50.00 I get 50.00000. How do I fix this. It shows
up
in excel the way I want.