| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turning a negative into a positive
Hello:
If you have a column of negative numbers, is there an easy way of changing them all at one time into positive numbers without having to take away the minus sign to each number individually? Thanks! childofthe1980s |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turning a negative into a positive
Hi childofthe1980s
In any spare cell type -1 then copy that cell, then select the column of negative numbers, then go Edit, Paste Special and select the Multiply operation, then click OK. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
| Some Positive, Some Negative | Excel Worksheet Functions | |||
| Turning positive numbers to negative | Excel Discussion (Misc queries) | |||
| Turning a negative into a positive | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Linear Mode
