| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerged 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. -- Laurie Jenkins Athens Insurance Client Services |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mailmerged Dollar Amount Problem
You need a formatting switch on the Word field - see
http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Laurie wrote: 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. |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mailmerged Dollar Amount Problem
to format for currency: { MERGEFIELD "your field name"\#"$###,###,##0.00" } "Laurie" wrote: 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. -- Laurie Jenkins Athens Insurance Client Services |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mailmerged Dollar Amount Problem
Or more elegantly
{ MERGEFIELD "your field name" \# "$,0.00" } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Nina wrote: to format for currency: { MERGEFIELD "your field name"\#"$###,###,##0.00" } "Laurie" wrote: 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. -- Laurie Jenkins Athens Insurance Client Services |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mailmerged Dollar Amount Problem
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! -- sg "Graham Mayor" wrote: You need a formatting switch on the Word field - see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Laurie wrote: 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. |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mailmerged Dollar Amount Problem
sueg,
About halfway down on G. Mayor's website, listed below. Format cash amounts to 2 decimal places {mergefield amount \# "$,0.00;($,0.00)"} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "sueg" wrote in message ... 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! -- sg "Graham Mayor" wrote: You need a formatting switch on the Word field - see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Laurie wrote: 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. |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mailmerged Dollar Amount Problem
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 -- 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 "sueg" wrote in message ... 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! -- sg "Graham Mayor" wrote: You need a formatting switch on the Word field - see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Laurie wrote: 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. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get dollar sign to appear upper left corner of amount? | Microsoft Word Help | |||
| adding 2 dollar amount | Microsoft Word Help | |||
| How do I add leading dots from text to Dollar amount? | Microsoft Word Help | |||
| Large dollar amount switch | Mailmerge | |||
| Dollar Amount Conversion | Microsoft Word Help | |||
Linear Mode
