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.