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.
I'm surprised why you can't reproduce no one of the suggestions, perhaps we misunderstood your question?
SergeiBaklan My question concerned using the Excel "Find" command to find a certain number stored as text; I thought the command didn't work. When I tried again after reading the responses, the find command did find my search term, whether it was stored as text or as a number.