Thanx a million.
Any idea why MSFT dosen't have a keyboard shortcut for
this one already?

jasonK.

-----Original Message-----
Shoulda mentioned,

DONT USE THIS ON CELLS CONTAINING FORMULAS

Dan E

"Dan E" wrote in
message ...
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.




.