TransWikia.com

Sort excel date column in dd-mm-yyyy format

Super User Asked by MYGz on December 29, 2020

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?

One 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.

Answered by MYGz on December 29, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP