[mdicke]

I would like to hide a field in a merge, but only if it's =0 in my Excel
spreadsheet. Otherwise, I would like the filed to show up as it normally
would. An IF statement with " " (quotes around a blank) doesn't seem to be
cutting it. Any suggestions? (Couldn't find anything on a couple of the MVP
sites referenced throughout this board.)

[Graham Mayor]

You can use a formatting switch on a numeric field
eg
{Mergefield Fieldname \# "0.00";
This is covered on my web site at
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



mdicke wrote:
I would like to hide a field in a merge, but only if it's =0 in my
Excel spreadsheet. Otherwise, I would like the filed to show up as
it normally would. An IF statement with " " (quotes around a blank)
doesn't seem to be cutting it. Any suggestions? (Couldn't find
anything on a couple of the MVP sites referenced throughout this
board.)

[mdicke]

Your suggestion of {Mergefield Fieldname \# "0.00";;} didn't work. And I
didn't see anything on your site that really showed what I was looking for.

Here's my field as it currently stands, and works returning me the correct
data:

{ MERGEFIELD O_08 \# $##.00 }

What I'd like to do (or think I need to do) is something like this:

{ IF { MERGEFIELD O_08 = 0 "" { MERGEFIELD O_08 \# $##.00 } }

or mabye just:

{ IF { MERGEFIELD O_08 = 0 "" \# $##.00 }

Whatever the case, I can't get the filed blank if there's a zero in that cell.

Thanks.
Matt

"Graham Mayor" wrote:

You can use a formatting switch on a numeric field
eg
{Mergefield Fieldname \# "0.00";
This is covered on my web site at
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



mdicke wrote:
I would like to hide a field in a merge, but only if it's =0 in my
Excel spreadsheet. Otherwise, I would like the filed to show up as
it normally would. An IF statement with " " (quotes around a blank)
doesn't seem to be cutting it. Any suggestions? (Couldn't find
anything on a couple of the MVP sites referenced throughout this
board.)

[Graham Mayor]

OK

{ IF { MERGEFIELD O_08 } 0 { MERGEFIELD O_08 \# "$,0.00"} }

If you want zeros suppressing also, add in the semi-colons to the switch
--

Graham Mayor - Word MVP

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


mdicke wrote:
Your suggestion of {Mergefield Fieldname \# "0.00";;} didn't work.
And I didn't see anything on your site that really showed what I was
looking for.

Here's my field as it currently stands, and works returning me the
correct data:

{ MERGEFIELD O_08 \# $##.00 }

What I'd like to do (or think I need to do) is something like this:

{ IF { MERGEFIELD O_08 = 0 "" { MERGEFIELD O_08 \# $##.00 } }

or mabye just:

{ IF { MERGEFIELD O_08 = 0 "" \# $##.00 }

Whatever the case, I can't get the filed blank if there's a zero in
that cell.

Thanks.
Matt

"Graham Mayor" wrote:

You can use a formatting switch on a numeric field
eg
{Mergefield Fieldname \# "0.00";
This is covered on my web site at
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



mdicke wrote:
I would like to hide a field in a merge, but only if it's =0 in my
Excel spreadsheet. Otherwise, I would like the filed to show up as
it normally would. An IF statement with " " (quotes around a blank)
doesn't seem to be cutting it. Any suggestions? (Couldn't find
anything on a couple of the MVP sites referenced throughout this
board.)

[mdicke]

PERFECT! Thank you!

"Graham Mayor" wrote:

OK

{ IF { MERGEFIELD O_08 } 0 { MERGEFIELD O_08 \# "$,0.00"} }

If you want zeros suppressing also, add in the semi-colons to the switch
--

Graham Mayor - Word MVP

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


mdicke wrote:
Your suggestion of {Mergefield Fieldname \# "0.00";;} didn't work.
And I didn't see anything on your site that really showed what I was
looking for.

Here's my field as it currently stands, and works returning me the
correct data:

{ MERGEFIELD O_08 \# $##.00 }

What I'd like to do (or think I need to do) is something like this:

{ IF { MERGEFIELD O_08 = 0 "" { MERGEFIELD O_08 \# $##.00 } }

or mabye just:

{ IF { MERGEFIELD O_08 = 0 "" \# $##.00 }

Whatever the case, I can't get the filed blank if there's a zero in
that cell.

Thanks.
Matt

"Graham Mayor" wrote:

You can use a formatting switch on a numeric field
eg
{Mergefield Fieldname \# "0.00";
This is covered on my web site at
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



mdicke wrote:
I would like to hide a field in a merge, but only if it's =0 in my
Excel spreadsheet. Otherwise, I would like the filed to show up as
it normally would. An IF statement with " " (quotes around a blank)
doesn't seem to be cutting it. Any suggestions? (Couldn't find
anything on a couple of the MVP sites referenced throughout this
board.)