View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Currency missing after mailmerge

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