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???

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???

Add a switch to the mergefield in Word, e.g.:

{ MERGEFIELD FieldName \# "$#,0.00" }

In article ,
Roberta wrote:

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???