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!
|