View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert Mark Bram Robert Mark Bram is offline
external usenet poster
 
Posts: 5
Default Displaying date in filter criteria

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
:)