Forum Discussion
Solved
Date formatting Excel
Hello all, Have been trying to get text formatted as dates correctly in Excel. Alas, nothing happens. Source is as follows: https://www.investing.com/commodities/crude-oil-historical-data Despit...
KirkExcel Copied the table and pasted as text into Excel. Then used Text to Columns on the data ribbon.
Selected the date column.
Step 1: Delimited, next
Step 2: Un-check all delimiters, next
Step 3: Select Date and MDY from the dropdown, Finish
Then it looks like in the attached file. Column A now has real dates.
KirkExcel Copied the table and pasted as text into Excel. Then used Text to Columns on the data ribbon.
Selected the date column.
Step 1: Delimited, next
Step 2: Un-check all delimiters, next
Step 3: Select Date and MDY from the dropdown, Finish
Then it looks like in the attached file. Column A now has real dates.
Thank you! This works!
KirkExcel Perhaps you want to look into Power Query. Then you don't have to bother with TTC in the future. Nothing difficult. All can be done by clicking in the user interface. Example attached.