Mailmerged Dollar Amount Problem

[Laurie]

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.

 

[Graham Mayor]

You need a formatting switch on the Word field - see
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Nina]

to format for currency:

{ MERGEFIELD "your field name"\#"$###,###,##0.00" }

 

[Graham Mayor]

Or more elegantly
{ MERGEFIELD "your field name" \# "$,0.00" }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[sueg]

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!

 

[Rich/rerat]

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>>


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!

 

[Doug Robbins - Word MVP]

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