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

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

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

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

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