Quick Excel question that needs an answer!

Caporegime
Joined
1 Nov 2003
Posts
35,691
Location
Lisbon, Portugal
Hi All,

I've got a massive spreadsheet here and one column titled "Date Received" and all the dates in the cells below are marked up as "DD/MM/YYYY"

Can someone quickly tell me how to sort these out into oldest first please?

Thanks :)

EDIT: Figured it out

DELETE PLS
 
Last edited:
Soldato
Joined
12 Jan 2006
Posts
4,551
Location
Edinburgh
Highlight column (or the whole sheet if you want each row to be sorted in line with the corresponding date), then:

Data - Sort - Sort By ("Date Received") - Ascending

That what you mean?
 

Voo

Voo

Associate
Joined
6 Jul 2006
Posts
113
Location
Hull, East Yorks
If you have used the custom date formatting of dd/mm/yyyy then you can just select the whole column and go to Data > Sort, if it gives a Sort Warning (it should do) then ensure you expand the selection and then choose the column you want to sort by and do Ascending.

That should do oldest dates at the top if u did it right.
 
Back
Top Bottom