Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All,
I am using the magnificent FilterCriteria tip as per http://j-walk.com/ss/excel/usertips/tip044.htm to display the filter criteria being used in AutoFilters. A question was asked on my blog about displaying the filter criteria as a date - if it is a date. http://robertmarkbramprogrammer.blog...omment-5150203 I.e. if I were to apply a custom filter: "is less than 15/01/2009", this is displayed: "<39828" Is there a way to change the macro code perhaps (or cell formatting) to make that "< 15/01/2009" instead? Thanks for any assistance! Rob :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Filter Not Displaying all results | Excel Discussion (Misc queries) | |||
Help with using filter criteria with date | Excel Worksheet Functions | |||
Auto filter not displaying number of results in status bar. | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Displaying autofilter criteria | Excel Worksheet Functions |