View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DavidM[_2_] DavidM[_2_] is offline
external usenet poster
 
Posts: 2
Default Format a text cell for searching

I need to search within Excel files for particular numbers.
I use the standard Find command for *.xls files containing Text but am
having no luck in this working. I think that the numbers were originally
entered as Numbers.
I have tried to re-format these numbers as Text (they are all in a single
column within each file) but unless I actually retype each number
individually the search does not recognise it/them.
Any ideas gratefully received. (I am actually trying to use the system as a
"where used" for some old bills of materials that I am researching)
Thank you
--
DavidM