| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort dates by dd/mm/yyyyy
I was able to sort in the format that you mentioned by selecting the column
with the dates, click on data then text to columns. Choose fixed width to keep your whole date in one cell. Click next until you get to where you can Then click where you can format your data. Choose the date, click finish and then do your sort. "Summer_Girl" wrote: Does anyone know how to sort dates my dd/mm/yyyy? I have checked my regional settings and they co-ordinate, but it keeps sorting by day regardless of the month. Any suggestions would help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
| Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
