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

ActualStartDate

1100203

1100526

1100708

1140423

1120523

<colgroup><col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <tbody> </tbody>

 

[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!