Thread: How to merge an Excel currency field into a merged doc with $ ,.0
View Single Post
  #2  
Old March 25th, 2010, 02:53 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
  
Posts: 18,297
Default How to merge an Excel currency field into a merged doc with $ ,.0
Add a formatting switch to the merge field
\# "$,0.00"
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Imelda" wrote in message
...
$14,507.00 in Excel goes into the Word merged document as 14507
How do I bring the formatting with the data?