Autofilter Problem

[bijan]

Hi all
I have a date column with YYYY/MM/DD format that Autofilter custom option
doesn't work on it, the format cell shows the column is date format but it
seems is not.I tried to change format to text,general and even custom but
nothing changed and still custom option don't retrieve proper filter.
any suggestion would be helpful
Thanks
Bijan

 

[Max]

Try converting all the "dates" to real dates. Select the entire col, click
Data > Text to Columns. Click Next>Next. In step 3 of the wizard, under Col
data format, check "Date", select from the droplist: YMD. Click to Finish. It
should all work properly now. The real dates will respond to date formatting,
autofilter, pivoting, etc. Success? hit the YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Dave Peterson]

If you changed the format of the cell to an unambiguous date format (like mmmm
dd, yyyy) and the cell still displayed yyyy/mm/dd, then the value isn't really a
date--it's just text masquerading as a date.

If your offending data is all in a single column, you can use this technique to
convert the text dates to real dates.

Select the column
Data|Text to columns (xl2003 menus)
fixed width
choose date -- ymd order
and finish the wizard.

Verify by changing the format.

Now test your autofilter to see if it works.