Excel 2002 - Filtering numbers
 

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?

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


"Mike Faulkner" wrote:

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?

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:

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


"Mike Faulkner" wrote:

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?