Sorting Column Values (Ascending Year)

Hi,

I have values in Column A ( row 5 onwards) in the form of YY_ABCD eg. 02_0030

The YY part shows the year and the part after the underscore "_" is a number.

I want to arrange this data in ascending year form. I have data here starting from the year 1950 to 2010 (50_XXXX to 10_XXXX). So after sorting the column should start from 50_XXXX to 10_XXXX ( including the year 2000 i.e. 00_XXXX).

Can anyone show me how to do this in Excel or through a macro ?

Thank You,
JN