Sort excel date column in dd-mm-yyyy format

Question

I sorted a dd-mm-yyyy date column but it doesn't gets sorted correctly.

This is how it looks like after sorting which is incorrect.

01-03-2018
02-02-2018
03-02-2018
03-03-2018
03-03-2018
04-03-2018
04-03-2018
04-12-2017
04-12-2017
05-03-2018
06-02-2018
06-12-2017

Any tips?

MYGz · Answer

After selecting date and selecting sort anything that looks like a number, as a number it is sorting correctly. Earlier I was selecting sort numbers and numbers stored as text separately.

Sort excel date column in dd-mm-yyyy format

One Answer

Add your own answers!

Ask a Question