MrExcel Publishing
Your One Stop for Excel Tips & Solutions

transpose sign of numbers


Posted by Julie on March 16, 2001 10:30 AM

Is there a short cut key or way to make a toolbar button to change selected ranges of numbers from negative to positive or positive to negative. I usually have to do this by doing an off sheet multiplication by -1. I need a faster way.


Posted by Ian on March 16, 2001 10:40 AM

You could copy a put -1 in a cell, copy it, and paste special over your range using the multiply function.

Posted by Mark W. on March 19, 2001 1:19 PM

Here's another (albeit, unusual) way to manipulate
the signs of your values. If you make it a point
to enter postive values as formulas (e.g., =1,
=3.1416) you could quickly change negative values
to positive ones by replacing their minus sign with
an equal sign. Conversely, you can change a postive
value to a negative one by changing its minus to
an equal sign. Having just dreamed this up I've
never used this technique, but... hey, if it works
for you...