Or just coerce those numbers to text:

=a2&""

And use ends with .99 when you filter that column.



Retail Services wrote:

I have a column of prices. All sale items end with ".99". I want to return
all items that are on sale.

I'm trying to use auto filter to find all items that end with "99" or ".99".
When I set this up, it returns nothing. I have tried using ends with "9",
changing the format to number, text, general. I have also tried using the
"contains" funtion. Nothing works.

I saw an article about using helper columns, which is fine, but I don't know
a formula for "Ends with".

Any idea why not.

--

Dave Peterson