I have a very large database where I want to filter out numbers that do
not have certain two digits as their last two. For example, the column
based on which I want to filter out data contains numbers like
197301310153. I want to filter out anything that does not end in 53.
I tried using a criterium with a formula such as
=RIGHT(TEXT(A5,"###########"),2)="53", where A5 contains the first
record of the database. I put this criterium in A2, and when I select
the advanced filter from the menu I make sure it does not look for a
column label, i.e. the criterium only refers to this cell A2. But this
does not filter out anything. Can anyone here help me?
Thanks in advance.

Margo Guda.