Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet with a column indicating "Receipts," "Deliveries," "In,"
and "Out." A second column has a series of values, all positive numbers. I need to change all the "Deliveries" and "Out" to negative values. I have tried filtering on "Deliveries" and "Out" and then using the Paste Special function, but when I remove the filter I find that every value has been changed to negative, not just the filtered records. Any suggestions on how to change just the desired values from positive to negative? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) |