LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 6
Default Strange to filter how please

hi good friends,

encountered a strange display on filtering for a column of dates.

it looks like this

some dates are on a cell format date as distinguished
most dates entered were on english dates.


20-Jul. (Mie.) ----[$-es-MX]d-mmm (ddd)
19-Jul (Tue) ---- [$-en-US]d-mmm (ddd)

however the Auto filtering shows only Jul,,19,20 ?

Any idea to setup consider showing the (ddd) as well on the dropdown list of the filter ?

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
Filter PivotTable dropdown items to match report filter Catherine D Excel Discussion (Misc queries) 1 August 16th 08 12:12 AM
Need Help: Strange, Strange Behavior ( Not Me. My Model! ) SteveM Excel Programming 2 December 16th 07 06:02 PM
Strange behaviour - very slow after filter Dan Excel Programming 2 November 23rd 07 01:51 PM
Excel auto filter doesn't recoginize case - won't filter AA from A Mikey Excel Discussion (Misc queries) 1 September 29th 05 08:18 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM

All times are GMT +1. The time now is 01:09 PM.

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

About Us

"It's about Microsoft Excel"