I use advance filter a lot. For some reason, I cannot get it to return rows
based on criteria for column A, which is a number formatted to text. If I
choose to filter the invoice number three columns over it returns the
filtered rows just fine.