Autofilter Hides All...

  • Thread starter Thread starter TomCat
  • Start date Start date
T

TomCat

I have a column that contains number/letter format 100ABC, 101DEF, etc. When
I do a custom filter to show all the cells that contain 100, etc., the entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat
 
It worked fine for me in my tests (using xl2003).

Maybe the values in the cell aren't really what you see?

Any chance that the cells have a custom format that changes the look, but not
the value?

What do you see in the formula bar when you have one of those cells selected?
 
Back
Top