Are the cell values derived from formulas? Then just set the formula value
to zero if the formula calculation is less than zero: =IF(A1*B1<0,0,A1*B1),
etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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!