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.