Only if the numbers are 5 digit that is

To give Roger a break, maybe he meant greater than 98999 and less than 100000
which would return any number from 99000 to 99999


Gord



Curious

If you are looking for numbers beginning with 99 why is Greater than 89999
logical?

That would return all numbers greater than 89999 and miss out numbers like 9902
or 999

To give Roger a break, maybe he meant greater than 98999 and less than 100000
which would return any number from 99000 to 99999

I am assuming 89999 was a typo.


Gord

On Sat, 18 Nov 2006 23:16:34 +0000, BizMark
wrote:


I thought Roger's answer was more logical, actually, FWIW.

Tonso Wrote:
Gord, David...that works fine! Thanks to all who replied!


Tonso

Roger Govier wrote:-
Hi

Could you try Greater than 89999

--
Regards

Roger Govier


"Tonso" wrote in message
oups.com...-
i am using xl 2002 for windows. my autofilter works fine for
selecting
a certain catagory, say 99235
or 348851. but if i try to use a Custom filter, specifically "Begins
with" then type in 99, it shows nothing. i have tried to use text
format, general format, and number format, with the same
result....all
the rows with data are hidden. what am i overlooking?

thanks

billy
--

Gord Dibben MS Excel MVP