Forum Discussion
Dates not Sorting
Hi I have attached an image, I am using the sort filter to put the dates in order and as you can see at the top three of the rows are not filtering correctly and just staying at the top, I wond...
Hi, Yes that is correct
Select from C5 down.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, click Next > and then Next > again.
Select DMY from the date dropdown.
Click OK.
The values should now be right-aligned, and sort correctly.