ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom format date cells-Autofilter doesn't work right (https://www.excelbanter.com/excel-discussion-misc-queries/148005-custom-format-date-cells-autofilter-doesnt-work-right.html)

honyacker

Custom format date cells-Autofilter doesn't work right
 
I have created a custom format for my cells (mmm dd). The autofilter works
correctly (June 1 then Aug 1).
When I format the cells as (mmm dd yy), the autofilter doesn't seem to
recognize it the same (Aug 1 07 shows before June 1 07).
The formats used to be fine without the year, but I need it now.
I want my autofilter to show in calendar sequence, not alphabetically or
numerically.
Any ideas?
Thanks,
Joe
Excel 2003




All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com