MICROSOFT EXCEL SORTING

Copper Contributor

I am very confused as to why sometimes I sort a large amount of data by the date column it works and other times it does not.  Here is a sample of one that would not sort by date correctly.

 

05-03-2022 DATA SORTING PROBLEM.jpg

 

 

3 Replies

@Yok33 Difficult to say without having a look at the file. Can you share the file (or at least the file with only the date column) via Onedrive, Dropbox or similar?

@Yok33 Remove the "Outline" on the Data ribbon and then the sort will work.

Screenshot 2022-05-03 at 19.40.53.png