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?

Autofilter Issue
 

Pre-format cells as Text or enter ' before date.


"PWS" wrote:

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?

Autofilter Issue
 

I wish!

Does any mVP or anyone one from Microsoft have a solution?

Is it possible to change that field (column) to a numeric
field rather than text? That way everything would work normally.

Autofilter Issue
 

Put 1 in an empty cell, format the cell as a date, copy the cell
select all text dates, do editpaste special and select multiply


--
Regards,

Peo Sjoblom



"PWS" wrote in message
oups.com...
I wish!

Does any mVP or anyone one from Microsoft have a solution?

Is it possible to change that field (column) to a numeric
field rather than text? That way everything would work normally.