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...
The dates are left-aligned. What happens if you select column C and set the horizontal alignment to General? I suspect that the first three will become right-aligned, while the others remain left-aligned. Is that correct?
- 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.
