Reverse the signs of values

  • Thread starter Thread starter DianeG
  • Start date Start date
D

DianeG

Is it possible to reverse all the signs in a worsksheet ie from negative to
positive in one go?

Thanks

diane
 
DianeG said:
Is it possible to reverse all the signs in a worsksheet ie from negative to
positive in one go?

Thanks

diane
Click to expand...

Diane,

Multiplying all by -1 will reverse all signs.

Beege
 
Put -1 in an empty cell
edit|copy

Select the range of numbers to reverse
Edit|paste special|check multiply and values.

Clear that cell with the -1 in it.

This will convert all positive to negative and all negative to positive. It'll
leave 0's alone.
 
Thanks to all who replied, I'll try them all!

Dave Peterson said:
Put -1 in an empty cell
edit|copy

Select the range of numbers to reverse
Edit|paste special|check multiply and values.

Clear that cell with the -1 in it.

This will convert all positive to negative and all negative to positive. It'll
leave 0's alone.
Click to expand...
 
DianeG said:
Is it possible to reverse all the signs in a worsksheet
ie from negative to positive in one go?
Click to expand...

Not quite sure what you want. But perhaps the following will help.

Put -1 into some cell, and copy (ctrl-C). Select the range with numbers to
be "reversed" (note: this can change positive to negative as well as change
negative to positive). Right-click and select Paste Special>Multiply. When
you are all done, you can delete the -1.

Caveat: Although the above will work when pasting to cells with formulas,
the results might be unexpected, depending on the formula. You will need to
experiment or analyze to see if "reversing" in this manner works, or if it is
even necessary. (Often, simply changing the signs of constants in worksheets
is sufficient.)
 
thanks very much

[email protected] said:
Not quite sure what you want. But perhaps the following will help.

Put -1 into some cell, and copy (ctrl-C). Select the range with numbers to
be "reversed" (note: this can change positive to negative as well as change
negative to positive). Right-click and select Paste Special>Multiply. When
you are all done, you can delete the -1.

Caveat: Although the above will work when pasting to cells with formulas,
the results might be unexpected, depending on the formula. You will need to
experiment or analyze to see if "reversing" in this manner works, or if it is
even necessary. (Often, simply changing the signs of constants in worksheets
is sufficient.)
Click to expand...
 
Back
Top