| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Quick way to change negative #s to positive
Alot of times at work I need to take a column of numbers and change them to
either postive or negative numbers. I would like to be able to select the cells I want then click a button to change the signs of all the cells I selected. Is there such a button, like a +/- button?? If not is the fastest way to do this I can find is to select the cells, hit ctrl H and replace the - with blank. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding negative and positive diffrence | Excel Worksheet Functions | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| switching values from positive to negative | Excel Worksheet Functions | |||
| highlighting positive or negative change | Excel Discussion (Misc queries) | |||
Threaded Mode
