 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / March 2008Mailmerged Dollar Amount Problem
In Office 2003 using Excel spread sheet with dollar amounts as a merge field in Word the dollar amount shows more then 2 decimal places in the Word document. It is formated in the Excel document to 2 decimal places and is showing the correct amount in the formula bar. How do I get Word to keep the formating or how do I format the merge field to show only 2 decimal places? Thank you for your help.  SignatureLaurie Jenkins Athens Insurance Client Services You need a formatting switch on the Word field - see http://www.gmayor.com/formatting_word_fields.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > In Office 2003 using Excel spread sheet with dollar amounts as a > merge field in Word the dollar amount shows more then 2 decimal > places in the Word document. It is formated in the Excel document to > 2 decimal places and is showing the correct amount in the formula > bar. How do I get Word to keep the formating or how do I format the > merge field to show only 2 decimal places? Thank you for your help. I had trouble finding what I need. How would you do it? I have a 2003 Excel field formatted in Excel as currency/automatic comma/2 decimal places. I need to merge this into a 2003 Word letter. Thanks for your help! Signaturesg > You need a formatting switch on the Word field - see > http://www.gmayor.com/formatting_word_fields.htm [quoted text clipped - 5 lines] > > bar. How do I get Word to keep the formating or how do I format the > > merge field to show only 2 decimal places? Thank you for your help. sueg, About halfway down on G. Mayor's website, listed below. Format cash amounts to 2 decimal places {mergefield amount \# "$,0.00;($,0.00)"} SignatureAdd MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> I had trouble finding what I need. How would you do it? I have a 2003 Excel field formatted in Excel as currency/automatic comma/2 decimal places. I need to merge this into a 2003 Word letter. Thanks for your help! Signaturesg "Graham Mayor" wrote: > You need a formatting switch on the Word field - see > http://www.gmayor.com/formatting_word_fields.htm [quoted text clipped - 5 lines] > > bar. How do I get Word to keep the formating or how do I format the > > merge field to show only 2 decimal places? Thank you for your help. See response to the other post onto which you tagged your question. See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm SignatureHope 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 >I had trouble finding what I need. How would you do it? I have a 2003 >Excel [quoted text clipped - 11 lines] >> > bar. How do I get Word to keep the formating or how do I format the >> > merge field to show only 2 decimal places? Thank you for your help. to format for currency: { MERGEFIELD "your field name"\#"$###,###,##0.00" } > In Office 2003 using Excel spread sheet with dollar amounts as a merge field > in Word the dollar amount shows more then 2 decimal places in the Word > document. It is formated in the Excel document to 2 decimal places and is > showing the correct amount in the formula bar. How do I get Word to keep the > formating or how do I format the merge field to show only 2 decimal places? > Thank you for your help. Or more elegantly { MERGEFIELD "your field name" \# "$,0.00" } Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > to format for currency: > [quoted text clipped - 10 lines] >> Jenkins Athens Insurance >> Client Services
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.