Didn't work. Still hides the entire column.

"Roger Govier" wrote:

Hi

Autofilter dropdownCustomBegins with100

--
Regards
Roger Govier

"TomCat" wrote in message
...
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