If say A1 thru A1000 have both positive and negative values, then in an
unused column enter:

=IF(A1<0,0,A1) and copy down. Then copy the new column and
paste/special/values back onto column A.
--
Gary''s Student - gsnu201001


"Rajiv" wrote:

Hi freindz,

I am working in one sheet. There are some negative (minus) value in some
cell. I want to replace it with zero with the use of formula.

Kindly suggest me, how can it possible.

Regards,

Rajiv