Date Conversion - Unidentified Format

All,

I am getting a text file with column contains the date contains the following values.

070321

070331

I wanted to how to convert this into correct date values.

If i open in this excel and format the column with date then i getting the value as

7/11/2092

7/21/2092

Any info?

a®s

Moderator message: date conversion questions = FAQ, please search for available information before posting.

Edited by: Thomas Zloch on Nov 15, 2010 12:55 PM