Forum Discussion
Solved
Date Formatting in Excel
Hello, I am running Windows 10 Pro on my desktop PC. I have Office 365. I have a spreadsheet in Excel and a column with the date format m/dd/yyyy. Is there a way to change the formatting to only show...
- Thank you. I will try this solution!
The "dates" are left-aligned, indicating that they are text values that look like dates.
I'd start by converting them to real dates:
- Select column A.
- On the Data tab of the ribbon, click Text to Columns.
- Click Next > twice.
- Select Date, then select MDY from the dropdown next to it.
- Click Finish.
Next, create a helper column to the right:
- In B2 enter the formula =TEXT(A2,"mm/dd")
- Fill down.
Finally, sort the entire range (not just column B) on column B.
See the attached version.