Date sorting issue in Excel
Solved
dimlo
Posted messages
29
Status
Membre
-
phirwo -
phirwo -
Hello,
Currently working on an Excel 2007 (English, but no difference so far), I am facing a sorting problem with dates.
Explanations:
- I received a file containing thousands of dates that I need to sort,
- When I apply a sort, the dates do not group by year, month, and day, but instead appear "one after the other" (format dd/mm/yyyy in the sort),
Remarks:
- when I increase the width of the column, the dates are left-aligned (instead of right-aligned as usual)
- when I click inside a cell, it turns into a "normal" date and thus becomes sortable.
Finally, nothing seems strange in the formats, the cells are indeed in date formats (and not text or anything else).
Thank you for your responses.
P.S.: I searched for an answer on Google, but I couldn't find anything.
Configuration: Windows XP / Safari 535.11
Currently working on an Excel 2007 (English, but no difference so far), I am facing a sorting problem with dates.
Explanations:
- I received a file containing thousands of dates that I need to sort,
- When I apply a sort, the dates do not group by year, month, and day, but instead appear "one after the other" (format dd/mm/yyyy in the sort),
Remarks:
- when I increase the width of the column, the dates are left-aligned (instead of right-aligned as usual)
- when I click inside a cell, it turns into a "normal" date and thus becomes sortable.
Finally, nothing seems strange in the formats, the cells are indeed in date formats (and not text or anything else).
Thank you for your responses.
P.S.: I searched for an answer on Google, but I couldn't find anything.
Configuration: Windows XP / Safari 535.11
14 réponses
Hello,
If your dates are on the left, it's because Excel sees them as text (most likely a result of an import).
To convert them to numeric:
- copy an empty cell
- select the dates
- special paste 'addition'
- set the desired date format.
If the conversion doesn't take place, it's because you have some unwanted characters to remove (spaces, non-breaking spaces, ...)
Eric
Edit: I just tested it on your file, it works.
If your dates are on the left, it's because Excel sees them as text (most likely a result of an import).
To convert them to numeric:
- copy an empty cell
- select the dates
- special paste 'addition'
- set the desired date format.
If the conversion doesn't take place, it's because you have some unwanted characters to remove (spaces, non-breaking spaces, ...)
Eric
Edit: I just tested it on your file, it works.
ach
Thank you, thanks to you my TDC is holding up!
phirwo
Great!
