LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Filter by month, then day, not just day

I have a shared excel 2003 file where in 1 column, there are dates (lots of
duplicates).
The autofilter works differently on different computers.
One computer, the drop down is organized by month first, then date.
But on other computers, it is organized by date first ( Jan 01, Feb 01, Mar
01,Jan 02, Feb 02, Mar 02)
I want to see Jan 1, Jan 2, Jan3, Feb 1, Feb 2, Feb 3 etc. in the drop down.
Is there a setting to fix this (or an add-in that is not installed on all
computers)?
Thanks,
Joe



 
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
Need to filter by month mikeybmdb Excel Discussion (Misc queries) 3 November 1st 05 01:53 PM
transfer cell $ amount to other sheet month-to-month without overc Colin2u Excel Discussion (Misc queries) 1 July 28th 05 02:36 AM
filter birthday's by month in Excel Lisa Peterson Excel Discussion (Misc queries) 3 July 6th 05 01:38 PM
Filter by month Marci Excel Discussion (Misc queries) 3 January 10th 05 05:53 AM
How can i filter dates based on day of month Saurabh Excel Worksheet Functions 1 December 12th 04 05:36 PM


All times are GMT +1. The time now is 10:34 AM.

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"