Thanks- it works! Any idea why the Auto Filter command won't work?

"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.