yes, to get it to display like that, it would be text, in that case, use
=right(a1,5)="25.00" I think you pretty much need a helper col for this kind
of thing.

"Ole" wrote:

Thanks. That works great.

Taking it to the next level...if my column is 200+98.00, 200+99.00,
201+00.00 etc. (I'm guessing these would be considered text, not number cells
because of the + symbol?) What kind of formula would alow me to filter for
all ending in 25.00 increment? (eg. 200+50.00, 200+75.00, 201+00.00,
201+25.00...)

"Per Jessen" wrote:

Hi

In an helper column insert this formula and copy it down:

=MOD(A1,10)

Now you can filter for '0' in the helper column.

Regards,
Per

"Ole" skrev i meddelelsen
...
I have a list of numbers (20000 to 27583)

I only want to see the info for the rows where the number ends with 0 (eg.
20000, 20010, 20020 etc. basically every 10th row)

When I custom filter for "ends with" 0, my whole list goes away.

.