how to change cell sign and values

[me]

How do you change the value of a number from positive to
negative and vice versa in excel 2000 ?

I need to do this with every number in the column. zeros
should be unaffected.

Thanks

 

[Nick Hodge]

In the next column, say B, enter =-B1 and copy down.

This will reverse the sign and leave zeroes un-affected

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Tom Ogilvy]

put -1 in a blank cell. Select the cell and do Edit=>Copy

Select all the cells you want to change (including cells containing zero)
and do Edit=>Paste Special and select Values and Multiply.

 

[simora]

Great!

Thanks.