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!

Thanks - that is exactly what I needed!

"Peo Sjoblom" wrote:

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


Regards,

Peo Sjoblom

"epowell74" wrote:

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!