LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mon Mon is offline
external usenet poster
 
Posts: 4
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto updating list Larry Excel Worksheet Functions 8 July 27th 06 01:59 PM
Cell reference in the auto filter custom list Andre Croteau Excel Discussion (Misc queries) 1 February 14th 06 02:03 PM
Custom Views Dropdown List Jim Palmer Excel Discussion (Misc queries) 3 June 22nd 05 10:22 PM
Using advanced filter to search for criteria in a list Potatosalad2 Excel Discussion (Misc queries) 1 June 8th 05 03:08 AM
How to filter and list data based on different data. Defoes Right Boot Excel Worksheet Functions 3 April 13th 05 04:03 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"