One way:
With the data in A1,
=DATE(LEFT(A1,3)+1900,MID(A1,4,2),RIGHT(A1,2))
and format the cell as the date format you want.
Jay
EDIT: If you are working with dates prior to 2000 and the first 2 digits (rather than 3) are 99 for example, use the more robust, but longer formula:
=DATE(LEFT(A1,LEN(A1)-4)+1900,MID(A1,LEN(A1)-3,2),RIGHT(A1,2))
This message was edited by Jay Petrulis on 2002-04-15 14:30