Or by using event code which looks at the value in the cell and changes to 0 if
negative.

No formulas involved, just VBA


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 15:29:00 -0800, Teethless mama
wrote:

=MAX(your formula,0)


"Terence" wrote:

Is it possible to format a cell where if the cell value is negative then
change the value to zero?

Thanks for your help!