|  | sorting base on date | | |
| | | crapit |  |
|  Posted: Fri Aug 29, 2008 8:52 am Post subject: sorting base on date |  |
how to sort based on a column of date that has either dd.mm.yyyy or
dd/mm/yyyy |
| |
| | | Dave Peterson | |
| | Posted: Fri Aug 29, 2008 10:08 am Post subject: Re: sorting base on date | |
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.
crapit wrote:
| Quote: |
how to sort based on a column of date that has either dd.mm.yyyy or
dd/mm/yyyy
|
--
Dave Peterson |
| |
| | | Bob Phillips | |
| | Posted: Fri Aug 29, 2008 10:09 am Post subject: Re: sorting base on date | |
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...
| Quote: | how to sort based on a column of date that has either dd.mm.yyyy or
dd/mm/yyyy
|
|
| |
| | | crapit | |
| | Posted: Sat Aug 30, 2008 10:55 am Post subject: Re: sorting base on date | |
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...
| Quote: | 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
|
|
| |
| | | Bob Phillips | |
| | Posted: Sun Aug 31, 2008 3:27 pm Post subject: Re: sorting base on date | |
| |  | |
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...
| Quote: | 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
|
|
| |
| | | crapit | |
| | Posted: Mon Sep 01, 2008 5:16 am Post subject: Re: sorting base on date | |
| | | |
it doesnt sort at all, i'm just showing a original unsort and after sort sample
"Bob Phillips" <bob.ngs@somewhere.com> wrote in message news:%232b3964CJHA.3668@TK2MSFTNGP05.phx.gbl...
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...
| Quote: | 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
|
|
| |
| | | Pete_UK | |
| | Posted: Mon Sep 01, 2008 9:01 am Post subject: Re: sorting base on date | |
| | | |
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
On Sep 1, 8:16 am, "crapit" <biggerc...@yahoo.com> wrote:
| Quote: | it doesnt sort at all, i'm just showing a original unsort and after sort sample
"Bob Phillips" <bob....@somewhere.com> wrote in messagenews:%232b3964CJHA.3668@TK2MSFTNGP05.phx.gbl...
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" <biggerc...@yahoo.com> wrote in messagenews: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....@somewhere.com> wrote in messagenews: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" <biggerc...@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
|
|
| |
|
|
