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

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
-----Original Message-----
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.
.