mailmerge to show cents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pcor - 10 Jan 2006 04:08 GMT

My Excel sheet has a field called "TOTAL"
Under that heading I have a number of "totals" such as
10.00
120.00
123.45
etc
I have inserted the "TOTAL" field as required but only the 123.45 entry
shows up properly. The other entries do NOT show the CENTS.
How do I go about formating to show TWO decimals(ie 10.00 or 120.00) ?
Thanks

Reply to this Message

Doug Robbins - Word MVP - 10 Jan 2006 04:59 GMT

This has got to be the most commonly asked question in this group.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> My Excel sheet has a field called "TOTAL"
> Under that heading I have a number of "totals" such as
[quoted text clipped - 6 lines]
> How do I go about formating to show TWO decimals(ie 10.00 or 120.00) ?
> Thanks

Reply to this Message

pcor - 10 Jan 2006 17:57 GMT

It was new to me but many thanks in any case.

> This has got to be the most commonly asked question in this group.
>
[quoted text clipped - 13 lines]
> > How do I go about formating to show TWO decimals(ie 10.00 or 120.00) ?
> > Thanks

Reply to this Message