C
crapit
how to sort based on a column of date that has either dd.mm.yyyy or
dd/mm/yyyy
dd/mm/yyyy
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.
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.
B
Bob Phillips
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)
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)
C
crapit
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
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
B
Bob Phillips
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)
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
--
HTH
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
C
crapit
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)
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
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)
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
P
Pete_UK
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
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