Date of Birth to proper date format

[jschrock]

Hello!

I have data formatted like this:

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]51767[/TD]
[/TR]
[TR]
[TD="class: xl66"]72236[/TD]
[/TR]
[TR]
[TD="class: xl66"]112380[/TD]
[/TR]
[TR]
[TD="class: xl66"]100886[/TD]
[/TR]
[TR]
[TD="class: xl66"]42466[/TD]
[/TR]
[TR]
[TD="class: xl66"]100665[/TD]
[/TR]
</tbody>[/TABLE]

The problem is that these are Dates of Birth and I need them to look like:

05/17/67
07/22/36
11/23/80
10/08/86
04/24/66
10/06/65

Any help would be great!

 

[Scott Huish]

With only 2 digit years, there is also a potential problem of 2 years being valid. 050118 could be May 1, 1918 or May 1, 2018