Excel into Table Date Problem

[Pappy]

I have an excel spreadsheet which pulled off an old database where the DOB was in the following format
21853
72738
92342

I would like to change these either in excel, or in access when imported in as

2/18/53 or if possible 2/18/1953
7/27/38 7/27/1938
9/23/42 9/23/1942

Right now if I change the format, excel will add new numbers. Thanks!

 

[FoFa]

what does it look like if it is 02/03/1956 as an example, is it 2356 or 20356? In other words, are there leading zeros?
You could use NewDate: iif(len([olddate]=6,left([olddate],2) & "/" mid([olddate],3,2) & "/19" & right([olddate],2),left([olddate],1) & "/" mid([olddate],3,2) & "/19" & right([olddate],2))

This is assuming the day is always zero filled (date length is always 5 or 6)
If there a 2000 DOB's then run a query chaning any year < 1904 to 200n.