Thread: Find/Replace
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DP7 DP7 is offline
external usenet poster
 
Posts: 54
Default Find/Replace

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.