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

Thanks

diane

Use the function ABS()

It will return the positive value of a cell
--
Yanick


"DianeG" wrote:

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

Thanks

diane

DianeG wrote:
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

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 wrote:

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

Thanks

diane

--

Dave Peterson

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

"Dave Peterson" wrote:

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 wrote:

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

Thanks

diane

--

Dave Peterson

"DianeG" wrote:
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 SpecialMultiply. 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

" wrote:

"DianeG" wrote:
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 SpecialMultiply. 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.)