Excel stores valid dates as numbers and displays them with a date format. If you only want a date to look different, change its number format. If you need a different calendar date, edit the cell’s actual value instead.
Change how a date is displayed
- Select the cells containing the dates.
- Open the Home tab.
- In the Number group, choose a built-in Short Date or Long Date format, or open More Number Formats.
- Select Date or Custom and choose the appearance you need.
For example, the same stored date might be displayed as 8/28/2026, August 28, 2026, or 28-Aug-2026. Formatting does not change which day the cell represents.
Create a custom date format
Custom formats give you more control. A format such as mmmm d, yyyy displays a full month name, while yyyy-mm-dd produces a year-month-day display. The exact result can also be affected by regional settings.
If Excel will not format the date
The value may be text rather than a real Excel date. This often happens with imported CSV files, copied web data, or dates written in a format Excel does not recognize for your locale.
Before converting a large column, determine whether entries such as 03/04/2026 mean March 4 or April 3. Changing the display format cannot correct a date that was interpreted incorrectly during import.
If you need to add or subtract days, months, or years, use date calculations or functions rather than manually changing the displayed text. Keeping dates as true date values allows Excel to sort, filter, chart, and calculate with them correctly.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.