Forum Discussion

Paul_Robinson's avatar
Paul_Robinson
Copper Contributor
Jan 30, 2020
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
Excel on Mac
  • Patrick2788's avatar
    Patrick2788
    Jan 30, 2020

    Paul_Robinson 

    Excel can locate it either way. Make sure you're not looking for a Format in addition to the number.

PReagan's avatar
PReagan
Bronze Contributor
Jan 30, 2020

Hello Paul_Robinson,

 

Be sure that "Match entire cell contents" is disabled.

Press Ctrl+F > Options > Uncheck "Match entire cell contents"

 

 

Resources