| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get a formula to work on visible cells with autofilter? | Excel Discussion (Misc queries) | |||
| custom autofilter does not work | Excel Discussion (Misc queries) | |||
| the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
| Can I format to always AutoFilter specific cells | Excel Worksheet Functions | |||
| Custom Time Format doesn't work for me | Excel Discussion (Misc queries) | |||
Linear Mode
