Hi,

You can write an IF formula like

=IF(A1<0,0,A1)

and copy it across the range.

Regards

Govind.

tcgaines wrote:

The subject says it all. I want to search a range for cell values that
are < 0 and if they are, change the value to 0. how do i do that?

thx