Try this:

=MAX(your formula,0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"sue" wrote in message
...
I am doing a inward/outward stocktake and sometimes it returns a negative
number. I want to be able to display this negative number as zero but
display
any positive numbers as they are.