| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change positive to negative and viceversa
how can i change positive values to negative values, and negative values to
positive values. for ex: column I row 5 150 to -150 row 7 200 to -200 row 9 -30 to 30 and so on |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change positive to negative and viceversa
Place a negative 1 in any blank cell and copy it. Then paste special over the
cells you want to flip the sign on selecting Multiply as the paste option... -- HTH... Jim Thomlinson "andresg1975" wrote: how can i change positive values to negative values, and negative values to positive values. for ex: column I row 5 150 to -150 row 7 200 to -200 row 9 -30 to 30 and so on |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change positive to negative and viceversa
Put -1 in an empty cell
edit|copy (that cell) select the range to fix edit|paste special|check multiply andresg1975 wrote: how can i change positive values to negative values, and negative values to positive values. for ex: column I row 5 150 to -150 row 7 200 to -200 row 9 -30 to 30 and so on -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change positive to negative and viceversa
And then clean up that cell with the -1.
andresg1975 wrote: how can i change positive values to negative values, and negative values to positive values. for ex: column I row 5 150 to -150 row 7 200 to -200 row 9 -30 to 30 and so on -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change positive to negative and viceversa
Thanks! This was very helpful!!!
"Jim Thomlinson" wrote: Place a negative 1 in any blank cell and copy it. Then paste special over the cells you want to flip the sign on selecting Multiply as the paste option... -- HTH... Jim Thomlinson "andresg1975" wrote: how can i change positive values to negative values, and negative values to positive values. for ex: column I row 5 150 to -150 row 7 200 to -200 row 9 -30 to 30 and so on |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change numbers from positive to negative. | Excel Worksheet Functions | |||
| how to change series of numbers from pos. to negative & viceversa | Excel Discussion (Misc queries) | |||
| Change from a negative to a positive | Excel Discussion (Misc queries) | |||
| How to change negative to positive | Excel Worksheet Functions | |||
| Change a positive value to a negative value | Excel Programming | |||
Linear Mode
