why is the search function not working in excel?
Make sure the you don't have a range of cells selected. I've also found that sometimes the formatting in the cell will mess with the search function. If it's a number stored as text then it may not work. ... Excel could be seeing your numbers as text.