keep the Dollar Values format in the excel data base from coming..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chammersmith - 19 Nov 2004 17:21 GMT

One of the fields of my mail merge is the amount paid. Even though I've
formatted the excel spreadsheet to currency and two decimal places. Word is
showing it as 295 instead of 295.00 and if there are cents in the data base,
it shows it as 295.359999. Any ideas how to fix this?

Reply to this Message

Graham Mayor - 19 Nov 2004 17:49 GMT

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> One of the fields of my mail merge is the amount paid. Even though
> I've formatted the excel spreadsheet to currency and two decimal
> places. Word is showing it as 295 instead of 295.00 and if there are
> cents in the data base, it shows it as 295.359999. Any ideas how to
> fix this?

Reply to this Message