Custom Autofilter
Have you got spaces (or other non-visible characters) before your numbers?
If in doubt, try a formula such as =LEFT(A1,5) to check what your numbers do
start with.
--
David Biddulph
"flumpf" wrote in message
...
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?
|