Prev Previous Post   Next Post Next
  #1   Report Post  
Debgala
 
Posts: n/a
Default sort dates

I have a report exported to XL as text file and converted to XL. The dates
appear as mm/dd/yy. I want to sort the dates by month & day, but want to
ignore the year. Is this possible? How?
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
sort dates by day then month, not by year. Lisa Peterson Excel Worksheet Functions 5 July 12th 05 10:38 AM
sort dates by month and day not year dianne Excel Worksheet Functions 2 March 8th 05 08:16 PM
How do I get Excell to sort dates that range from 1800 to 1900's Smith295 New Users to Excel 1 February 22nd 05 06:20 PM
How sort dates just by day/month and NOT year if all 3 given in ce smags Excel Worksheet Functions 1 January 25th 05 03:45 AM
Need to sort dates before 1900 in proper order sandage_2000 Excel Discussion (Misc queries) 3 January 8th 05 03:31 AM


All times are GMT +1. The time now is 04:16 AM.

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

About Us

"It's about Microsoft Excel"