Reverse the signs of values

[DianeG]

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

Thanks

diane

 

[Yanick]

Use the function ABS()

It will return the positive value of a cell

 

[Beege]

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

Thanks

diane

Diane,

Multiplying all by -1 will reverse all signs.

Beege

 

[Dave Peterson]

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.

 

[DianeG]

Thanks to all who replied, I'll try them all!

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.

 

[joeu2004]

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

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.)

 

[DianeG]

thanks very much

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.)