| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the display of negative values to parentheses? | New Users to Excel | |||
| How can I display negative numbers as zeros? | Excel Discussion (Misc queries) | |||
| is there a function to change negative values to zero? | Excel Worksheet Functions | |||
| How can I change all negative values in a column to = 0? | Excel Worksheet Functions | |||
| Unwanted Zeros in Excel Chart Displayed Values | Excel Discussion (Misc queries) | |||
Threaded Mode
