Prev: How do I test whether a string is a valid cell reference?
Next: How do you convert a string to a double?
From: Phil Hibbs on 15 Apr 2010 08:39
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.
From: p45cal on 15 Apr 2010 11:34

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


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195823

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: How do I test whether a string is a valid cell reference?
Next: How do you convert a string to a double?