Apr 15 2021 02:25 PM
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 |
The first is August 6, 2020 ect..
I need an easy way to update all of these to a date I can work with like 08/06/2020. I tried using the date formatting before and after changing the way my computer interprets dates - neither worked. I found the date function that will take the general number and change to a date 2020/08/06 - at this point I can use formatting to switch it around but how would I copy that too all the other cells? I can only copy the formula that will put the date from the source but I want the formula to use the data in my new cell.
Apr 15 2021 02:34 PM
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.