Multiply by -2 and then divide by 2?
--
David Biddulph

"FARAZ QURESHI" wrote in message
...
Can anyone help me out in revealing a way that all the positive numbers in
a
worksheet would convert to negative ones and negative ones to positive
ones,
without multiplying with -1.

Since I further need to calculate upon the same I want to change not only
the format but also the true nature. In other words some way other than
choosing a custom format.

If no other simple way, macros are welcome.