Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive)

  • Thread starter Thread starter M Stokes
  • Start date Start date
M

M Stokes

I have frequent need to quickly reverse the sign on all data in a
column from positive to negative or negative to positive.

For example, the column that contains the data I want to reverse sign
on is Column A.

So far my "caveman" approach has been to:
1. add a temporary Column B and copy down -1 for all rows for which
column A has data
2. next create a temporary Column C and copy down the formula Column
A * Column B for all rows for which Column A has data
3. next Copy Column C and do a Paste Special Values over Column A
4. finally, delele temporary Columns B and Column C.

Is there an easier way to do this. Heard you could do using Paste
Special and use the Operation Section. However, when I use muliply it
simply squares the data.
 
Hi
see yur other post. you already received several answers

P.S.: please don't multipost
 
Back
Top