sort dates

S

sokevin

hI

My dates use the system dd/mm/year


if i press the sort button.. it will sort by day->month->year

I want to sort by year->month->day

how do i do this??

thank
 
F

Fred Smith

The best thing to do is to store your data as real Excel dates. Then they
will always sort properly, regardless of which format you display the date
in.

As you have numbers, rather than dates, sorting isn't so easy. The choices
are:
1. Create a Date field (=Date(year,month,day)) and sort on that.
2. Split out the day, month and year, then sort on the three separate
columns.
 
Top