try this
Sub Replacedashwoscientific()
Set myrng = Range("M1:M10")
For Each c In myrng
c.Value = "'" & c
Next
myrng.Replace "-", "", LookAt:=xlPart
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DP7" wrote in message
...
I have to remove the dashed from the text that follows. 2-604-E53. My
problem
is that when I use find/ replace it converts the text to scientific
notation.
I have literally hundreds of lines to remove the dashed from. I have tried
changing the format to text the doing the find/replace & it still converts
the text to scientific notation. If anybody has any ideas it would be much
appreciated.