Assistance needed (Have to convert string of numbers into dates)

**connmtc** · 03-21-2013, 06:40 PM

3-21-2013 6-38-39 PM.png

Enrollment Begin
20060109
20060830
20070110
20070827
20080114
20080527
20080902

Anyone able to assist in restructuring the string of numbers into a date. I'm new to macros and this has had me stumped for 2 days. Any help is greatly appreciated.

**TMS** · 03-21-2013, 06:47 PM

Select the column of dates.
Select Text to Columns
Choose Delimited; Next; Next; Date: YMD; Finish

Regards, TMS

**tigeravatar** · 03-21-2013, 06:51 PM

connmtc,

Welcome to the forum!
This can be done with a formula, but if it has to be VBA, something like this should work:

Please Login or Register  to view this content.

**connmtc** · 03-21-2013, 06:53 PM

Cheers! That was a lot easier than I would have thought. Thanks a lot!

**TMS** · 03-21-2013, 08:23 PM

You're welcome. Not sure which approach you opted for ...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.