Forum Discussion
excel date formatting and sorting
I have a column of dates which is in the following format:
eg. '05-Aug-2020 04:24'
which shows the date month year, and then the time
How do I sort by date, I tried sorting it but i could only figure out how to sort it by the first two digits
3 Replies
- Hi, this could be because any field could makes it a text field and so you are only able to sort it with the first 2 digits. (If you look at the filter option, it would show text filters)
You need to make sure the format is Date. You can use Custom Number format "dd-mmm-yyyy hh: mm" to display in the format you want. Make sure you have no am or pm displayed after the date and time. limzhiyangg Why not upload a file with several dates as you have them. Perhaps they are in fact texts an then sorting will not give you the desired effect.
- yes they are in text form, I tried to format them into dates, however, it does not work.
I tried formatting them while they are in the form ' Apr 20 2021 ' , but nothing happens.
But when i put it as '20 Apr 2021', the formatting process is successful
