Remove the negative sign


Posted by Alexia on February 06, 2002 1:00 PM

I currently have a macro that makes numbers negative in a selected range by simple making the value "-" & Cell.Value

Is there anyway to write something that would do the reverse of this, that is, remove the negative sign in each cell of the selected range?

Thanks



Posted by Mark W. on February 06, 2002 1:51 PM

Selection.Replace What:="-", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False