Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort column in date order dd/mm/yy
In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems
to sort on the first 2 digits. I have formatted the cells to date, but it still does not seem to work Can you help? K |
#2
|
|||
|
|||
Are you sure that they're dates?
If you format those cells as: mmmm dd, yyyy do they change to a long date format? If they stay like dd/mm/yy, then your values aren't really dates--they're text masquerading as dates. If you select that columns of false dates, you can convert them to real dates by using: Data|text to columns choose dmy as the format for that field. K wrote: In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems to sort on the first 2 digits. I have formatted the cells to date, but it still does not seem to work Can you help? K -- Dave Peterson |
#3
|
|||
|
|||
Very useful info as I imported data from Access, it only gives me date in
text masquerading. Although I know how to change it under format cell or format painter but only one cell each time which was a big pain for me, thanks a lot Jennifer "Dave Peterson" wrote: Are you sure that they're dates? If you format those cells as: mmmm dd, yyyy do they change to a long date format? If they stay like dd/mm/yy, then your values aren't really dates--they're text masquerading as dates. If you select that columns of false dates, you can convert them to real dates by using: Data|text to columns choose dmy as the format for that field. K wrote: In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems to sort on the first 2 digits. I have formatted the cells to date, but it still does not seem to work Can you help? K -- Dave Peterson |
#4
|
|||
|
|||
If the "dates" are in one column, did you try the data|text to columns
technique? If the dates are all over the place, maybe you can just select your cells edit|replace what: / (slash) with: / (slash) replace all. jen wrote: Very useful info as I imported data from Access, it only gives me date in text masquerading. Although I know how to change it under format cell or format painter but only one cell each time which was a big pain for me, thanks a lot Jennifer "Dave Peterson" wrote: Are you sure that they're dates? If you format those cells as: mmmm dd, yyyy do they change to a long date format? If they stay like dd/mm/yy, then your values aren't really dates--they're text masquerading as dates. If you select that columns of false dates, you can convert them to real dates by using: Data|text to columns choose dmy as the format for that field. K wrote: In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems to sort on the first 2 digits. I have formatted the cells to date, but it still does not seem to work Can you help? K -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
Date in descending order to come up automatically in a column? | Excel Worksheet Functions | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |