Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge to show cents
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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge to show cents
It was new to me but many thanks in any case.
"Doug Robbins - Word MVP" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Mailmerge with Access via DDE | Mailmerge | |||
Mailmerge from Excel my numbers do not stay as 2 decimals. Help | Mailmerge | |||
Trying to suppress Select Table box in Excel-Word mailmerge | Mailmerge | |||
Method for displaying dollar amount as written on bank check | Microsoft Word Help | |||
Included Property in Word 2003 MailMerge | Mailmerge |