Put this formula in any cell other than A1 and you will get a "0" if A1 is
less than zero (negative).
IF(A1<0,"0","Whatever")
If you want a given cell to change to "0" whenever its value goes negative,
you will need a macro. Post back if you need more. HTH Otto
"mike" wrote in message
...