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?