simple dates & Filtering question??

[Yaseen Al-Lawati]

i have a column with dates (dd/mm/yyyy)
i formated the cells to dates.
then i filtered them from the drop down box to Acsending.
the problem is it orders them first in dd wise then mm wise then yyyy wise
where as I want it to start yyyy wise then mm wise then dd wise
could anyone help me ??
yaseen

 

[Stephen Wolstenholme]

i have a column with dates (dd/mm/yyyy)
i formated the cells to dates.
then i filtered them from the drop down box to Acsending.
the problem is it orders them first in dd wise then mm wise then yyyy wise
where as I want it to start yyyy wise then mm wise then dd wise
could anyone help me ??
yaseen

Hello,

Select all the date cells and change the format to yyyy-mm-dd

Steve

 

[Yaseen Al-Lawati]

I did that already as I mentioned
by the way the date cells are reffered from data base
so I don't write the date