ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   custom section of filter list? (https://www.excelbanter.com/excel-discussion-misc-queries/104425-custom-section-filter-list.html)

Mon

custom section of filter list?
 
When yo have an autofilter on a list of dates set in the following format:
yy-mmm-dd and you select the "custom" uption from the drop down menu, it ony
recognizes the date as dd-mm-yy. How do I make this "custom" section of the
filter list recognize my date format?

I ahve already adjusted the regional settings accordingly and changed the
sell format to custom: yy-mmm-dd.

Please advise.

Thanks

[email protected]

custom section of filter list?
 
Hi Mon,
I would be very thankful if you could contact me via e-mail regarding
an older newsgroup entry of you. I am experiancing the same problem
(not that one you descripe in this thread, I just coudn't find a way to
contact you because you're mailadresse seems to be outdated and the
older thread is already closed).

If there is a way, I will delete this entry afterwards!
Thanks in advance, hopefully I hear from you
Michael



All times are GMT +1. The time now is 01:38 AM.

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