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 on...
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.
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.