software

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?

Are you talking about mailmerge? Make the currency values text

=TEXT(A1,quot;$#,##0.00quot;)

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

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

all you need to know including quot;force word to use the number format you
wantquot;

--

Regards,

Peo Sjoblom

Nothwest Excel Solutions

www.nwexcelsolutions.com

remove ^^ from email

quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Curt in Virginiaquot; lt;Curt in gt; wrote in
message ...
gt;I have currency formatted numbers in a column that I merge into a Word
gt; document. When I do the merge, the $ sign, comma and period do not follow
gt; into the word document. What am I doing wrong?