Excel 2002 - Filtering numbers

[Mike Faulkner]

Hello. I am having problems filtering out phone numbers starting with 230745*
in a column. I can filter out text but not numbers. Any ideas?

 

[Duke Carey]

If the entries truly are numbers, and assuming they are 10 digit numbers,
then you need to use one criteria of

=2307450000

and another of

<=2307459999

 

[Stefi]

I found this solution:
Autofilter doesn't work with digits as if they were other characters (e.g.
letters) even if the column is formatted as text (@). But if you use a helper
column containing a TEXT function referring to the original column (e.g. put
in cell B2 =Text(A2,"@") ) then Autofilter works on column B in the style
starting with 230745*.

Regards,
Stefi



„Duke Carey†ezt írta: