View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjobom
 
Posts: n/a
Default Currency merge from Excel to Word

Are you talking about mailmerge? Make the currency values text

=TEXT(A1,"$#,##0.00")

then copy and paste special over the old values and then delete any help
cells where you put the formula, then try to mailmerge

http://word.mvps.org/FAQs/MailMerge/index.htm

all you need to know including "force word to use the number format you
want"

--

Regards,

Peo Sjoblom

Nothwest Excel Solutions

www.nwexcelsolutions.com

remove ^^ from email

"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curt in Virginia" <Curt in wrote in
message ...
I have currency formatted numbers in a column that I merge into a Word
document. When I do the merge, the $ sign, comma and period do not follow
into the word document. What am I doing wrong?