Dollar Signs and Zero Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erika - 20 Jan 2004 20:34 GMT

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)

Reply to this Message

Graham Mayor - 21 Jan 2004 06:55 GMT

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)"}"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am attempting to merge a Word document and an Excel
> spreadsheet. When I merge the 2 together I lose my dollar
[quoted text clipped - 6 lines]
>
> {Mergefield Amout \#"$#.00;($#.00)

Reply to this Message

Erika - 21 Jan 2004 19:51 GMT

Excellent - thank you for your help!

>-----Original Message-----
>the switch \# ",$#.00" should produce nothing for an empty field and $ .00
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 21 Jan 2004 20:17 GMT

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
[quoted text clipped - 6 lines]
>
> {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 :-)

Reply to this Message