I have imported a worksheet from excel.

I am trying to use query criteria to seach.
the feild I am trying to search was a custom 000-000-000 cell.

I have been trying to use like "001*" but am getting nothing back.

what should I do. Do I need to change the info in excel and start over?

thanks

If you get nothing back than there is nothing starting with 001

I can clearly see that there are numbers that start 001!

Numbers can't start with "00". Text strings can. Even though you can make Excel display the "001", once it gets into Access, it may convert it to "1". When you open the imported table to display the data, does it show "001-blah blah blah"?

BTW, I had this exact problem when importing SSNs from Excel.