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 wondered if anyone knows why this is happening.
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?
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.
Hi FinAndo12
In the picture you shared the dates are left aligned. This usually means they are Text values, hence they don't sort as you expect
Assuming your dates are in Column A, starting in Row 2:
