Text to Date

Occasional Visitor

How do I convert this to Short Date?

20200317
20200317
20210802
20211025
20210726
2 Replies

@MomofChase 

Select the values.

On the Data tab of the ribbon, click Text to Columns.

Click 'Next >' twice.

Select Date, and select YMD from the dropdown next to Date.

Click Finish.

One other way you could do it with a formula (format cell to short date):
=--TEXT(A1,"0000\/00\/00")