Forum Discussion
Solved
Date Formatting Issue Excel
Hello,
For some reason half the dates in the columns 'Date' and 'Start Date' are in a different format. I can format half of them as dates and hence group by month/year but the rest seem to be ignoring all format attempts. Help would be much appreciated. Ideally would need a column showing Month / Year, or at least the ability to group by month/year in a pivot.
Thanks
Jenny
The values that resist formatting are text values, not real dates, even though they look like dates.
You can do the following:
- Select column A.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Next > twice.
- In step 3 of the wizard, select Date, then select MDY from the dropdown next to it.
- Click OK.
- Repeat these steps for column D.
2 Replies
The values that resist formatting are text values, not real dates, even though they look like dates.
You can do the following:
- Select column A.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Next > twice.
- In step 3 of the wizard, select Date, then select MDY from the dropdown next to it.
- Click OK.
- Repeat these steps for column D.
- Thank you!
