Forum Discussion
Date formatting Excel
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.
