Reverse the sign of a number in a cell

[epowell74]

I'd like to create a formula that I can use to reverse the sign of a number.
The problem I'm having is that the formula cannot contain a reference to the
cell itself because it then loses the value. I realize that I can do this
through VBA, but I wondered if there was another way to do this. It seems
like this would be a fairly common thing to do.

Thanks in advance for your help!

 

[epowell74]

Thanks - that is exactly what I needed!

If you want to reverse negative/postive, put -1 in an empty cell, copy it,
select the numbers, do edit>paste special and select mulitply


Regards,

Peo Sjoblom