Literal string in filter, not a date

[Phil Hibbs]

I have text cells with dates in them in ISO format, embedded in the
text of the cell. I want to filter on cells that contain a certain
date, e.g. 2010-03-15 but when I put that into the AutoFilter it gets
automatically converted to 15/03/2010 which does not appear in the
cell. How can I tell the filter that I am looking for a literal
string, and not to interpret it as a date?

Phil Hibbs.

 

[p45cal]

try
*2010-03-15
even if the string is right at the left of the cells I think it wil
still detect and show it.