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