Mail Merge from and Excel Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 10 Oct 2003 00:58 GMT

When I complete a mail merge from an excel database in
word, I open the merged documents. As the database
contains $ values with decimal places, I need the letters
to show 2 decimal places. This is fine when there is a
whole figure at the end of the information, however when
it is something like $35.30, everything will show up
except the 0 at the end. Can I overcome this?

Reply to this Message

Greg Maxey - 10 Oct 2003 01:46 GMT

Matt,

Try a numerical switch in your mergefield

{ your mergefield \# "$,#.00;($,#.00)" }

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
Remove the obvious (wham...m) to reply in e-mail

> When I complete a mail merge from an excel database in
> word, I open the merged documents. As the database
[quoted text clipped - 3 lines]
> it is something like $35.30, everything will show up
> except the 0 at the end. Can I overcome this?

Reply to this Message