mailmerge to show cents
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
|