Currency missing after mailmerge

[Guest]

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

 

[Peo Sjoblom]

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

 

[JE McGimpsey]

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

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