simple dates & Filtering question??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yaseen Al-Lawati - 16 Mar 2008 10:51 GMT

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

Reply to this Message

Stephen Wolstenholme - 16 Mar 2008 11:13 GMT

>i have a column with dates (dd/mm/yyyy)
>i formated the cells to dates.
[quoted text clipped - 3 lines]
>could anyone help me ??
>:( yaseen

Hello,

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

Steve

Signature

Neural Planner Software Ltd http://npsl1.com
EasyNN-plus. Build Neural Networks. http://www.easynn.com
SwingNN. Forecast the Future. http://www.swingnn.com

Reply to this Message

Yaseen Al-Lawati - 16 Mar 2008 11:55 GMT

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

> >i have a column with dates (dd/mm/yyyy)
> >i formated the cells to dates.
[quoted text clipped - 9 lines]
>
> Steve

Reply to this Message