Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |