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