Text date field yyyymm conversion to date

[ballor]

I have a large spreadsheet with dates in text format, YYYYMM. I used the Text to Columns option and selected Date YMD. When i attempt to convert the cell to dates it converts 201801 into the year 2452, July. Any suggestions?

 

[steve the fish]

You will have to use a formula or code. Formula:

=DATE(LEFT(A1,4),RIGHT(A1,2),1)

 

[ballor]

You will have to use a formula or code. Formula:

=DATE(LEFT(A1,4),RIGHT(A1,2),1)

Thanks, that did the trick!