How do I change my negative values to zeros in Excel?

[N_Davis]

I need to convert data from mg/L to mg/kg, but before I can do that I need to
get rid of my negative values. How do I change, for example, -0.005 to zero
without manually doing so (I have hundreds of negative values and do not have
the time or patience to do so)?

 

[Harald Staff]

Hi

Helper column with formula like
=MAX(A1,0)
Fill down, then replace formula with values.

HTH. Best wishes Harald