Dear Sir,

You please convert the year format to "yyyy" or if you have typed yea
as numbers
sort them and use the formula so you will get full year data
Example

=CONCATENATE("20",C1) ' if C1 VALUE IS 04

will give 2004

I hope this will work for you.

Regards
S.Sures

--
s_u_res
-----------------------------------------------------------------------
s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27202