Forum Discussion

Copper Contributor

Dec 03, 2017

sorting date column oldest to newest

I imported a csv file of my connections from linkedin and I want to sort them by the date we connected. Even though I mark the whole column (F) to be a date column, so they become date cells (align...

excel

Haytham Amairah

Silver Contributor

Dec 04, 2017

1904 date system option isn't related!

Go back to advanced options and uncheck its checkbox!

Local date settings are found in Control Panel >> Region and Language.

But I don't recommend you to change them!

To solve the problem follow these steps:

Step 1

Sort the column that contains the dates from oldest to newest in order to move the text dates to the bottom.

Step 2

Highlight the text dates as shown in the below screenshot, and keep them highlighted.

Step 3

Go to Data >> Data Tools >> Text to Columns.

Step 4

In Text to Columns window click Next twice.

Step 5

Select Date from the Column data format group box, and select the date format of text dates that you have previously highlighted., If its format is US format (MDY), select it and hit Finish as shown in the below screenshot:

AmarCheema

Copper Contributor

Sep 09, 2019

This really worked for me. Thanks for taking the effort to share.