Mailmerge with Excel as a database... Suppressing zero's in fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 19 Aug 2005 13:27 GMT

Hello,
Could someone help me with this? I am using an excel database to populate a
form in Word. It is calculating dollar values and bringing them into Word.
I can't seem to suppress the zero's in fields that should be blank because
there is no value. I have been to G Mayor's site and tried what is there but
it does not seem to work. Any suggestion's???

Thanks in advance,
Mike

Reply to this Message

Doug Robbins - 19 Aug 2005 18:13 GMT

What formatting switch are you using?

To show positive and negative amounts but nothing for zero amounts, use:

\# "$,0.00;-$,0.00;"

or

\# "$,0.00;($,0.00);"

To just show the positive amounts, use:

\# "$,0.00;;"

Signature

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

> Hello,
> Could someone help me with this? I am using an excel database to populate
[quoted text clipped - 8 lines]
> Thanks in advance,
> Mike

Reply to this Message

Michael - 19 Aug 2005 18:26 GMT

Thanks for your input Doug. I tried earlier what you had suggested, but
somehow I could not get it to work. What I eventually used (and works well)
was this:
{if {mergefield fieldname} <> 0 "{mergefield fieldname}" }

Thanks again!
Mike

> What formatting switch are you using?
>
[quoted text clipped - 22 lines]
> > Thanks in advance,
> > Mike

Reply to this Message

Graham Mayor - 20 Aug 2005 06:02 GMT

Did you update the field after adding the switch?

{Mergefield Amount \# ",$0.00;(,$0.00);" }
should work. How did you enter it?

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks for your input Doug. I tried earlier what you had suggested,
> but somehow I could not get it to work. What I eventually used (and
[quoted text clipped - 38 lines]
>>> Thanks in advance,
>>> Mike

Reply to this Message

Michael - 22 Aug 2005 12:13 GMT

Hi Graham,
Looking at your switch, I do believe that I didn't use the first comma. I
am fairly new to this. I did although update the field. I am sure if I would
have input the comma I would have had better results :)

Mike

> Did you update the field after adding the switch?
>
[quoted text clipped - 43 lines]
> >>> Thanks in advance,
> >>> Mike

Reply to this Message

Graham Mayor - 22 Aug 2005 14:49 GMT

The first comma is the thousands separator. It will work in countries that
use a comma as such.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi Graham,
> Looking at your switch, I do believe that I didn't use the first
[quoted text clipped - 59 lines]
>>>>> Thanks in advance,
>>>>> Mike

Reply to this Message

Rate this thread: