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!