Feb 01 2022 02:52 PM
How do I convert this to Short Date?
20200317 |
20200317 |
20210802 |
20211025 |
20210726 |
Feb 01 2022 03:10 PM
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.
Feb 01 2022 07:36 PM