Or you could insert a helper column and convert the real numbers to text (that
looks like numbers).

Either
=a2&""
or
=text(a2,"000000000")
if you want to preserve leading 0's

Then filter by that helper column.

" wrote:

I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534,
etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after
clicking ok the screen is blank, no records are found. What am I missing here?

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Beta 6
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

--

Dave Peterson