how about
Sub replaceminuw()
Selection.Replace What:="-", Replacement:="", LookAt:=xlPart
End Sub

--
Don Guillett
SalesAid Software

"Nih" wrote in message
...
Alot of times at work I need to take a column of numbers and change them
to
either postive or negative numbers. I would like to be able to select the
cells I want then click a button to change the signs of all the cells I
selected. Is there such a button, like a +/- button?? If not is the
fastest
way to do this I can find is to select the cells, hit ctrl H and replace
the
- with blank.