converting raw characters to a date

[mad3]

I have a file where column 'S' has a number in it that represents the date. When the file is received, the number is actual text at first. I need to convert it to a date. The first character is a number one followed by the next two characters representing the year, the second two characters representing the month, and finally the last two representing the day. Looking for a quick way to convert to a date format. I have more than 10K of lines in four different columns with date formats such as this one. Below is a sample of one column.

Thanks...Mike in California
[TABLE="width: 79"]
<colgroup><col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <tbody>[TR]
[TD="class: xl64, width: 105, bgcolor: transparent"]ActualStartDate[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1100203[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1100526[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1100708[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1140423[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1120523



[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

If you are looking for a formula solution, give this one a try...

=0+TEXT(19000000+A1,"0000-00-00")

Format the cell you put it in with the date display format you want.

 

[mad3]

If you are looking for a formula solution, give this one a try...

=0+TEXT(19000000+A1,"0000-00-00")

Format the cell you put it in with the date display format you want.

Thanks so much! Worked perfectly!