View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N_Davis N_Davis is offline
external usenet poster
 
Posts: 1
Default How do I change my negative values to zeros in Excel?

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