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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
Hi

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

HTH. Best wishes Harald
 
Back
Top