Mail Merge Question

  • Thread starter Thread starter Phillip Vong
  • Start date Start date
P

Phillip Vong

Using Office 2003

I have a Word doc merging with some data in XLS. In the xls field, I have
chosen the currency format and it looks fine. (ex. $125.75)

When I merge it in Word, it comes over as 125.75 and I have no idea how to
tell it to use the format I have set up in xls.

Please help.!

Thanks in advance.

Phil
 
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/assistance/HA011164951033.aspx

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

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

about half way down the page.

==========
Another way is to cheat!

Use a helper cell with a formula like:
=text(a1,"$##0.00")
and copy down

This will be treated like text in your mail merge.
 
Thanks so much!!!! That fixed it!

Dave Peterson said:
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/assistance/HA011164951033.aspx

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

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

about half way down the page.

==========
Another way is to cheat!

Use a helper cell with a formula like:
=text(a1,"$##0.00")
and copy down

This will be treated like text in your mail merge.
Click to expand...
 
Back
Top