trying to do custom autofilter but its not recognising "*"as wild

[max power]

i am trying to use the auto filter and have selected custom under custom i
have selected "does not equal to" and the typed "6500*" but it is still
showing all rows that contain data like 650011, 650009, 650006.

[Debra Dalgleish]

You can't use wildcards to AutoFilter for a number within a number.
You could add a column in which you calculate the left 4 characters of
the number:

=LEFT(G2,4)

Then, AutoFilter that column for 6500.

max power wrote:
> i am trying to use the auto filter and have selected custom under custom i
> have selected "does not equal to" and the typed "6500*" but it is still
> showing all rows that contain data like 650011, 650009, 650006.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html