How do I change my negative values to zeros in Excel?
Hi
Helper column with formula like
=MAX(A1,0)
Fill down, then replace formula with values.
HTH. Best wishes Harald
"N_Davis" wrote in message
...
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)?
|