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.