Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Autofiltering Dates - stored as string
Is there a way to Autofilter a column of dates, when these dates are stored as strings?. 15 Apr 2007 15 Apr 2007 15 Apr 2007 16 Apr 2007 16 Apr 2007 17 Apr 2007 17 Apr 2007 17 Apr 2007 When I set the Custom Autofiler, using 'does not equal' and then selecting '16 Apr 2007' from the drop-down list, this has no effect. When I return to the Custom Autofiler dialog I notice that the criertia has been changed to 39188. The format of the cells are set to text, but Excel will not leave the criteria as a string it converts it to a number - can this be stopped? If not how do I filter my range of text dates only showing thoese which match a criteria which is a valid date as a string? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum Issue Help! | Excel Discussion (Misc queries) | |||
Issue | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
IF Issue | Excel Worksheet Functions | |||
#VALUE! issue | Excel Worksheet Functions |