Number Format
Thanks Dave, that worked perfect!
"Dave F" wrote:
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!
|