Dollar Signs and Zero Values

[Erika]

I am attempting to merge a Word document and an Excel
spreadsheet. When I merge the 2 together I lose my dollar
signs and my decimals - though this site I found how to
put the switch in the field code to get the dollar sign
and that decimal but but now when the value is empty in
the spreadsheet I get a 0 in my mail merge document - is
there more that I need to add to the switch I put in -
Currently my merge field reads like this

{Mergefield Amout \#"$#.00;($#.00)

 

[Graham Mayor]

the switch \# ",$#.00" should produce nothing for an empty field and $ .00
for a zero entry.
If you want $0.00 change the switch to \# ",$0.00;(,$0.00)"

If the data is returning 0 for an empty field and you want it to remain
empty you'll need a conditional field

{IF {Mergefield Amount} <> 0 "{Mergefield Amount \# ",$0.00;(,$0.00)"}"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Erika]

Excellent - thank you for your help!

-----Original Message-----
the switch \# ",$#.00" should produce nothing for an empty field and $ .00
for a zero entry.
If you want $0.00 change the switch to \# ",$0.00; (,$0.00)"

If the data is returning 0 for an empty field and you want it to remain
empty you'll need a conditional field

{IF {Mergefield Amount} <> 0 "{Mergefield Amount \# ",$0.00;(,$0.00)"}"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>





.

 

[Cindy M -WordMVP-]

Hi Erika,

In this case, it might be better to go back to the older way
of connecting to Excel, DDE. You'll find instructions on how
to do this in the Word 2002 section of my website's Mail
Merge FAQ. This would be a lot easier than also having to nest
your mergefield into an IF field.

You could also pull the old mail merge helper out and use
that, instead. Instructions for that are also on my website.

I am attempting to merge a Word document and an Excel
spreadsheet. When I merge the 2 together I lose my dollar
signs and my decimals - though this site I found how to
put the switch in the field code to get the dollar sign
and that decimal but but now when the value is empty in
the spreadsheet I get a 0 in my mail merge document - is
there more that I need to add to the switch I put in -
Currently my merge field reads like this

{Mergefield Amout \#"$#.00;($#.00)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail