Currency merge from Excel to Word

G

Guest

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

Peo Sjobom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dollar amounts aren't merging from Excel into a Word document... 3
Excel currency format does not translate correctly in a Word merge 2
How do I merge from Excel into Word doc and retain formatting? 4
Using Excel as data for mail merge... 1
in mail merge how do i convert currency from excel to word 1
How do I carry format into word using mail merge? 1
Mail Merge 4
Mail Merge to Microsoft Word 2

Top