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
<colgroup><col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;">
<tbody>
</tbody>
Thanks...Mike in California
ActualStartDate |
1100203 |
1100526 |
1100708 |
1140423 |
1120523 |