If you change the currency values (in the source data in Excel) to text
instead it should carry it over, otherwise look here
http://word.mvps.org/FAQs/MailMerge/index.htm
look at the "force word to use the number format you want" under formatting
mail merge results
--
Regards,
Peo Sjoblom
"Roberta" wrote in message
...
I have an existing Excel Document with currency. I am attempting to do a
mail merge in word using the Excel Document as my datasource. It pulls
everything over, but it does not pull over the actual Excel formatting.
For
example, instead of $300.00 all I get is 300. or instead of 300.60 all I
get
is 300.6, or instead of 0.00 all I get is 0. It will not bring over the
decimals and zeros. Do you have an option I could try???