 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007sorting date
Hi- I have a list of dates in a column that I want to sort by- the problem is that it sorts it in a way that makes no sense to me- is there a way to sort by year/month in ascending manner? Thanks Brent Brent, It sounds as if they're not true dates, but text. If you do Format - Cells - Number tab, and set it to General, you should get a number if they're true dates. If they still look like dates, they're not true dates, but plain old text. As such, they'll only sort alphamerically, not in date order.  SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > Hi- I have a list of dates in a column that I want to sort by- the problem is that it > sorts it in a way that makes no sense to me- is there a way to sort by year/month in > ascending manner? > > Thanks > Brent Hi Brent, You shouldn't have any trouble sorting dates if they are Excel dates. So first of let's see what you actually have. If your your date is in column A then paste the column into another sheet as values. A2: contains a date B2: =ISNUMBER(A2) C2: =Text(A2,"yyyy-mm-dd hh:mm:ss") Check to see what the number format of A2 is Select A2, Format, cells, ... what do you see on the left that is highlight, and what on the right then select custom format (format, cells, custom) what do you see there. There are additional things that you can check see http://www.mvps.org/dmcritchie/excel/join.htm#debugformat Signature--- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hi- I have a list of dates in a column that I want to sort by- the problem > is that it sorts it in a way that makes no sense to me- is there a way to > sort by year/month in ascending manner? > > Thanks > Brent Brent I suspect the dates are not being seen as so by Excel or you have a regional issue problem SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk > Hi- I have a list of dates in a column that I want to sort by- the problem > is that it sorts it in a way that makes no sense to me- is there a way to > sort by year/month in ascending manner? > > Thanks > Brent |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.