View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PWS PWS is offline
external usenet poster
 
Posts: 18
Default Autofilter Issue

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?