How do I merge from Excel into Word doc and retain formatting?
 

I'm using mailmerge to merge currency numbers from Excel into Word docs.
Seems to work fine with one exception, the dollar sign and the comma does not
merge. Merging from cells with formulas. solution?

How do I merge from Excel into Word doc and retain formatting?
 

Works fine for me, what results do you get and what do you expect


--

Regards,

Peo Sjoblom

"John" wrote in message
...
I'm using mailmerge to merge currency numbers from Excel into Word docs.
Seems to work fine with one exception, the dollar sign and the comma does
not
merge. Merging from cells with formulas. solution?

How do I merge from Excel into Word doc and retain formatting?
 

Peo,

Instead of getting $3,000 I get 3000 when I merge. I thought it might be
that I'm merging a formula but that's not it because it does the same for any
currency number.

"John" wrote:

I'm using mailmerge to merge currency numbers from Excel into Word docs.
Seems to work fine with one exception, the dollar sign and the comma does not
merge. Merging from cells with formulas. solution?

How do I merge from Excel into Word doc and retain formatting?
 

Debra Dalgleish posted this to a similar question:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

John wrote:

I'm using mailmerge to merge currency numbers from Excel into Word docs.
Seems to work fine with one exception, the dollar sign and the comma does not
merge. Merging from cells with formulas. solution?

--

Dave Peterson

How do I merge from Excel into Word doc and retain formatting?
 

Thanks Debra. solved my problem!

"Dave Peterson" wrote:

Debra Dalgleish posted this to a similar question:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

John wrote:

I'm using mailmerge to merge currency numbers from Excel into Word docs.
Seems to work fine with one exception, the dollar sign and the comma does not
merge. Merging from cells with formulas. solution?

--

Dave Peterson