Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a sheet with a list of dates formatted "ddd dd mm yy". It would be
useful to be able to jump to a particular date using autofilter, but the drop down box offers the various dates in an order determined by the formatted version of the date (all Fridays, then Mondays, Saturdays, Sundays, Thursdays, Tuesdays and Wednesdays). It would be more helpful if the drop down box looked at the underlying date data and ordered the alternatives accordingly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Formatting date fields after export | Excel Discussion (Misc queries) |