It depends whether the content of your cells is text, or numbers in Excel
date format.
If the former, you'd be better chaging it to the latter, then the sort will
be easy.
--
David Biddulph

Prem Soni wrote:
Hi,

I have a excel sheet of my company employees details with their date
of birth (i.e. 20-Mar-71) detail.
now i want to short all rows by employee date of birth in acceding
order. like this:
18-Jul-1982
01-Aug-1985
08-Sep-1991
22-Nov-1986

Kindly suggest me on this.....

Thanks....
PREM SONI