Auto Filter problems

[tbo]

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]

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)

 

[tbo]

Thank you very much, it worked!

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)