Forum Discussion
Complex date conversion
I received a large workbook with a string of dates formatted as general that are also in an odd order for my needs. For example these are some of the dates 20200806 20200804 20191105 Th...
Select the dates in a single column (if you have multiple columns with such values, you'll have to handle each of them separately).
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Click Next > again.
In Step 3, select Date, then select YMD.
Click Finish.
If necessary, widen the column and specify the desired date format.
- Perfect! Thank you so much!!!
