Auto Filter problems
 

I have a list of numbers I auto-filtered. When I try to run a custom
filter using ends with or begins with it show no results (there should
be results) It works fine if I use the equal condition. Any ideas why
it isn't working with begins with or ends with?

Auto Filter problems
 

Real numbers won't work the way you want.

But if you add a helper column and convert that number number to a text number,
you could filter on that helper column.

You could use:

=text(a2,"0000.000")
or
=a2&""

to convert to text (depending on what you want to see)

wrote:

I have a list of numbers I auto-filtered. When I try to run a custom
filter using ends with or begins with it show no results (there should
be results) It works fine if I use the equal condition. Any ideas why
it isn't working with begins with or ends with?

--

Dave Peterson

Auto Filter problems
 

Thank you very much, it worked!


Dave Peterson wrote:
Real numbers won't work the way you want.

But if you add a helper column and convert that number number to a text number,
you could filter on that helper column.

You could use:

=text(a2,"0000.000")
or
=a2&""

to convert to text (depending on what you want to see)

wrote:

I have a list of numbers I auto-filtered. When I try to run a custom
filter using ends with or begins with it show no results (there should
be results) It works fine if I use the equal condition. Any ideas why
it isn't working with begins with or ends with?

--

Dave Peterson