ID Number to birthday date

[grahamward]

Hi Forum. I have a database of ID (social security) numbers, which also represent the persons birthdate. For example the ID number 6803126300186, would mean that the persons birthday is 12 March 1968. Would anyone know how to extract this from Excel, so that a date can be displayed for multiple ID numbers?

 

[grahamward]

Thank you for all your help everyone. Much appreciated.

 

[Fluff]

Glad we could help & thanks for the feedback.