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