Date formatting trouble

Hello!

I am sure this question has been asked plenty of times before but I am just learning excel and only know some very basic stuff.

I have a worksheet with data imported from somewhere else and there is a column of dates which are like: 1222018 and appear to be formatted to General. I need them to be formatted as actual dates. So I need 1222018 to show up like 1/22/2018.

Simply changing the format to date gives me the date of whatever the serial number and shows up like 10/7/5245. After doing some research online i have tried using text to columns but it doesnt appear to do anything. I have tried some formulas but keep getting errors.

I wanted to convert the entire column into date format.

Thanks!

1st Jan looks like 112018

31st May looks like 5312018

Also looking closer it looks like something like Feb 8 is 2082018

So the dates appear to be MDDYYYY in General format. I can just add the / between the numbers and it formats it into the actual date but there are 100s of them.

Here is an example copied from the spreadsheet:

1112018
1112018
1222018
1242018
1252018
1252018
1252018
2062018
2062018
2062018
2082018
2082018
2232018

Yes, that is all correct - you got it!

Jan to September are all 7 characters and all 1 character days have a 0

October, November, and December are all 8 characters

Yes! AlKey, that worked beautifully!

Thank you both so much for your help; it's greatly appreciated. It was getting pretty frustrating trying to figure it out.