mailmerge to show cents

[pcor]

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

 

[Doug Robbins - Word MVP]

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


--
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

 

[pcor]

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

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


--
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