Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pcor
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pcor
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mailmerge with Access via DDE Jim Gilligan Mailmerge 0 November 22nd 05 01:21 PM
Mailmerge from Excel my numbers do not stay as 2 decimals. Help M.Darlene Mailmerge 1 July 29th 05 02:59 AM
Trying to suppress Select Table box in Excel-Word mailmerge Denise Mailmerge 4 June 21st 05 01:08 PM
Method for displaying dollar amount as written on bank check samandmonty Microsoft Word Help 5 May 11th 05 10:54 PM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd 04 11:26 AM


All times are GMT +1. The time now is 10:11 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"