Forum Discussion
date conversion not responding
That probably means that the column contains text values, not real dates.
Select the column.
On the Data tab of the ribbon, click Text to Columns.
Click Next > twice.
In Step 3, select Date, and select the format (MDY, DMY, ...) matching the values in the column from the dropdown.
Click Finish.
Can you format the values now?
I have attempted that several times, I should mention that the cell is concatenated. I am not sure if that is a problem. But I have attempted that format step several times to no avail.
- HansVogelaarOct 14, 2020MVP
Could you attach a sample workbook without sensitive data?
- john_burrelljOct 14, 2020Copper Contributor
- HansVogelaarOct 14, 2020MVP
This isn't going to work. Excel doesn't recognize dates before the year 1900.
If you want to display the values as MM/YYYY, use
=D2&"/"&C2
You won't be able to perform date calculations with these values for the reason mentioned above.