Multiply with -1
=A2*-1
or you can put -1 in an empty cell, copy it, select the values (or
preferably a copied range of the values in case you need to go back to the
original for any reason), do editpaste special and select multiply
--
Regards,
Peo Sjoblom
(No private emails please)
"relliman" wrote in
message ...
hi
I believe there is a way that you can change values on screen that are
positive to negative or vice versa!!
I would be really grateful if someone could tell me how??!!!
--
relliman
------------------------------------------------------------------------
relliman's Profile:
http://www.excelforum.com/member.php...o&userid=29105
View this thread: http://www.excelforum.com/showthread...hreadid=488276