Reverse the sign of a number in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse string on multiply cells 3
Reverse the signs of values 6
How to subtract a number from a Mergefield? 0
reverse a series of numbers from 1 cell into another 4
Function to reverse the sign of a cell 2
How do I prefix a worksheet of numbers with a Minus (-) Sign 4
Convert number to text as displayed 3
Spurious Formula Omits Adjacent Cells 2

Back
Top