At my business we use a certain format for our sales orders. In 2004 we
had a format of the job number and the year, such as 4304 or 1704. For
some reason, our autofilter cannot seem to sift through this. For
instance, after applying our autofilter to the sales order column on
our spreadsheets, even using the search 'contains' or 'ends with' 04
won't bring up all the items that contains or ends with 04.

Can anyone explain/help correct this problem?


--
Kompressor
------------------------------------------------------------------------
Kompressor's Profile: http://www.excelforum.com/member.php...o&userid=24209
View this thread: http://www.excelforum.com/showthread...hreadid=378207