Converting to Date Format in Excel

I have a lengthly spreadsheet that lists a milestone date as follows: 201708 201709 201708 201711 201712 201709 I need to convert these to date format (August 2017 or 08/20...

excel

brendasc

Copper Contributor

May 05, 2017

Selected the column and Entered the formula you indicated =DATE(LEFT(A1,4),RIGHT(A1,2),1), but got #VALUE! in the column header row and the rest of the numbers in the column didn't change. Then I tried the Format Cells path you mention and got mm/yyyy in all of the cells in the column. Took out the "" before and after the custom set and my numbers changed to dates, but they looked like this:
04/2452
04/2452
04/2452

(these dates were supposed to be corresponding to this:
201708
201709
201708