View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default DOB short in acceding order

Hi,

At the risk of pointing out the obvious why not select them and then

Data|Sort select the column and ascending and sort

Mike

"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