 |
 | 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 / September 2008sorting base on date
how to sort based on a column of date that has either dd.mm.yyyy or dd/mm/yyyy Change all your text dates to real dates. If they are all in dmy order, then I'd go into windows control panel and make sure my short date is set to this same dmy order. Then just change all the . to / and change all the / to / And then I would give that range an unambiguous date format (mmmm dd, yyyy) and check if my dates are what I expect them to be. Your results could be dates--just not what they really should be. Then sort your data. And after you've verified them, you can change the windows short date back to the order you like. > how to sort based on a column of date that has either dd.mm.yyyy or > dd/mm/yyyy  SignatureDave Peterson As Excel stores dates as the number of days since 1900, sorting should be no problem, irrespective of the format they are shown in. SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > how to sort based on a column of date that has either dd.mm.yyyy or > dd/mm/yyyy Before sorting 01.11.1976 31.08.1983 24.11.1952 24.06.2002 23.04.1976 18.12.1973 16.05.1980 05.09.1983 After Sorting 24.11.1952 18.12.1973 23.04.1976 01.11.1976 16.05.1980 31.08.1983 05.09.1983 24.06.2002 But it doesnt works as you had say in the previous reply > As Excel stores dates as the number of days since 1900, sorting should be no > problem, irrespective of the format they are shown in. > >> how to sort based on a column of date that has either dd.mm.yyyy or >> dd/mm/yyyy Which of those has been sorted out of order in your view? SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Before sorting 01.11.1976 31.08.1983 24.11.1952 24.06.2002 23.04.1976 18.12.1973 16.05.1980 05.09.1983 After Sorting 24.11.1952 18.12.1973 23.04.1976 01.11.1976 16.05.1980 31.08.1983 05.09.1983 24.06.2002 But it doesnt works as you had say in the previous reply "Bob Phillips" <bob.ngs@somewhere.com> wrote in message news:eC7Fv$cCJHA.1816@TK2MSFTNGP06.phx.gbl... > As Excel stores dates as the number of days since 1900, sorting should be no > problem, irrespective of the format they are shown in. > > -- > HTH > > Bob > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > "crapit" <biggercrap@yahoo.com> wrote in message > news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl... >> how to sort based on a column of date that has either dd.mm.yyyy or >> dd/mm/yyyy >> > > > it doesnt sort at all, i'm just showing a original unsort and after sort sample Which of those has been sorted out of order in your view? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "crapit" <biggercrap@yahoo.com> wrote in message news:OZJzh%23pCJHA.4340@TK2MSFTNGP02.phx.gbl... Before sorting 01.11.1976 31.08.1983 24.11.1952 24.06.2002 23.04.1976 18.12.1973 16.05.1980 05.09.1983 After Sorting 24.11.1952 18.12.1973 23.04.1976 01.11.1976 16.05.1980 31.08.1983 05.09.1983 24.06.2002 But it doesnt works as you had say in the previous reply "Bob Phillips" <bob.ngs@somewhere.com> wrote in message news:eC7Fv$cCJHA.1816@TK2MSFTNGP06.phx.gbl... > As Excel stores dates as the number of days since 1900, sorting should be no > problem, irrespective of the format they are shown in. > > -- > HTH > > Bob > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > "crapit" <biggercrap@yahoo.com> wrote in message > news:%23ZkYIVcCJHA.5196@TK2MSFTNGP04.phx.gbl... >> how to sort based on a column of date that has either dd.mm.yyyy or >> dd/mm/yyyy >> > > > Are you saying that this is what you would like to have happen, but it doesn't happen now? I suspect that all your "dates" are really text values, as a full-stop is not normally used to delimit dates. Convert them to real dates as explained earlier, then you should be able to sort. Hope this helps. Pete > it doesnt sort at all, i'm just showing a original unsort and after sort sample > Which of those has been sorted out of order in your view? [quoted text clipped - 64 lines] > > > > |
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.