Format a text cell for searching

[Guest]

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

 

[Guest]

If you want, send sample to toppers at REMOVETHISjohntopley.fsnet.couk