simple dates & Filtering question??

  • Thread starter Thread starter Yaseen Al-Lawati
  • Start date Start date
Y

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
 
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
 
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
 
Back
Top