Changing the sign of cell using a macro
Jason,
Here's one that'll change the signs of all selected cells
Sub ChangeSign()
For Each c In Selection
c.Value = -c.Value
Next
End Sub
Dan E
"Jason Knauff" wrote in message ...
Does anyone have a macro written that will change the sign
(from positive to negative or negative to positive) of a
number in a cell in excel? Or, does MSFT already have a
keyboard shortcut for this operation? Please help.
|