Forum Discussion
date conversion not responding
I am trying to format a date column to MM/YYYY, however, none of my attempts to change the column are working.
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.
Could you attach a sample workbook without sensitive data?
