Forum Discussion
Solved
Find can't "see" numbers stored as text
I need to work with an institutional spreadsheet (in other words, I can't change it) that has a column that includes numbers stored as text. If I type, for example, "406731" (without the quotes) in t...
Excel can locate it either way. Make sure you're not looking for a Format in addition to the number.
Thanks, PReagan, Twifoo , Patrick2788 , and SergeiBaklan , all good suggestions. With some embarrassment, I have to admit that I can't reproduce this. The only thing I can think is that I inadvertently had a range of cells selected. I marked Patrick2788 's as the best response for the "Excel can locate it either way" part.
Glad you found the solution. Next time it comes up you won't forget it. It's a great way to learn!