Software

Ask something
Discussion Locked

Sorting dates in Excel

0 helpful
5 replies

by shepler

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I received an Excel file from a client that has two columns with dates xx/xx/xxxx. I need to sort the sheet by the first date column from newest full date (i.e., 10/01/2001 would come before 1/02/2001). I usually don't have a problem with this butthis file keeps sorting based on the month only. Help!!

5 replies

by vorsossion

You should be able to go to data>sort>ascending/descending and get it to sort correctly, however if your machine is being persnickety about it, you can go and enter a "0" (zero) before each month that only has 1 digit making 1/2/2001 into 01/02/2001.

Also, make sure that it is 1/2/2001 and not 1/2/2002 this would make a big differance in the sorting process.

This discussion is closed to new replies.