[Carol]

How do i hide a zero balance in word.

[Stefan Blom]

Use a numeric picture switch to specify different formats for positive,
negative, and zero results. The following simple example with a formula
field:

{ = 35 \# "00.00;(00.00);" }

would display 35.00 (since 35 is positive). A negative result would display
in parentheses, and a zero result would not display at all.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
news
How do i hide a zero balance in word.

[Carol]

Hi

Thanks very much, however it is still not working correctly. In my formula i
have the following caluculation =d6*1.175-d6. (This is calculating the VAT
on D6 then subtracting the amount, leaving just the VAT amount) .

Where would i insert the numeric picture switch?

Thanks

"Stefan Blom" wrote:

Use a numeric picture switch to specify different formats for positive,
negative, and zero results. The following simple example with a formula
field:

{ = 35 \# "00.00;(00.00);" }

would display 35.00 (since 35 is positive). A negative result would display
in parentheses, and a zero result would not display at all.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
news
How do i hide a zero balance in word.

[Stefan Blom]

Edit the formula directly in the document: Press Alt+F9 to see the field
code. You'll see something like this: { = D6*1.175-D6 }. At the end of the
field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you want
for positive and negative results). Press Alt+F9 to hide field codes. Press
F9 to update the field.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
...
Hi

Thanks very much, however it is still not working correctly. In my formula
i
have the following caluculation =d6*1.175-d6. (This is calculating the
VAT
on D6 then subtracting the amount, leaving just the VAT amount) .

Where would i insert the numeric picture switch?

Thanks

"Stefan Blom" wrote:

Use a numeric picture switch to specify different formats for positive,
negative, and zero results. The following simple example with a formula
field:

{ = 35 \# "00.00;(00.00);" }

would display 35.00 (since 35 is positive). A negative result would
display
in parentheses, and a zero result would not display at all.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
news
How do i hide a zero balance in word.

[Carol]

Fantastic. It works great!! Thank you very much.

"Stefan Blom" wrote:

Edit the formula directly in the document: Press Alt+F9 to see the field
code. You'll see something like this: { = D6*1.175-D6 }. At the end of the
field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you want
for positive and negative results). Press Alt+F9 to hide field codes. Press
F9 to update the field.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
...
Hi

Thanks very much, however it is still not working correctly. In my formula
i
have the following caluculation =d6*1.175-d6. (This is calculating the
VAT
on D6 then subtracting the amount, leaving just the VAT amount) .

Where would i insert the numeric picture switch?

Thanks

"Stefan Blom" wrote:

Use a numeric picture switch to specify different formats for positive,
negative, and zero results. The following simple example with a formula
field:

{ = 35 \# "00.00;(00.00);" }

would display 35.00 (since 35 is positive). A negative result would
display
in parentheses, and a zero result would not display at all.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
news How do i hide a zero balance in word.

[Stefan Blom]

You are welcome.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
...
Fantastic. It works great!! Thank you very much.

"Stefan Blom" wrote:

Edit the formula directly in the document: Press Alt+F9 to see the field
code. You'll see something like this: { = D6*1.175-D6 }. At the end of
the
field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you
want
for positive and negative results). Press Alt+F9 to hide field codes.
Press
F9 to update the field.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
...
Hi

Thanks very much, however it is still not working correctly. In my
formula
i
have the following caluculation =d6*1.175-d6. (This is calculating the
VAT
on D6 then subtracting the amount, leaving just the VAT amount) .

Where would i insert the numeric picture switch?

Thanks

"Stefan Blom" wrote:

Use a numeric picture switch to specify different formats for
positive,
negative, and zero results. The following simple example with a
formula
field:

{ = 35 \# "00.00;(00.00);" }

would display 35.00 (since 35 is positive). A negative result would
display
in parentheses, and a zero result would not display at all.

--
Stefan Blom
Microsoft Word MVP



"carol" wrote in message
news How do i hide a zero balance in word.