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
HIS

"me" wrote in message
...

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