The fastest way to change how dates look
Open the cells with dates you want to reformat. Select them by clicking the first cell, holding Shift, and clicking the last cell in the range. Right-click and choose Format Cells. On the Number tab, click Date in the Category list on the left. The preview shows you what your dates will look like. Pick the format you want from the list and click OK.
That is the standard path for most date changes. If you need a format that is not in the list — like a custom order or language — you can build one yourself in the same dialog by clicking Custom at the bottom of the Category list and typing a code. But the built-in formats cover most work.
Key Takeaways
- Select the cells with dates, right-click, and choose Format Cells to open the formatting dialog.
- The Date category shows dozens of preset formats, and you can preview each one before you explore it.
- Custom formats let you build a date style that is not in the preset list by typing a code like mmm d, yyyy for "Jan 15, 2024".
- Changing the format does not change the actual date stored in the cell — it only changes how Excel displays it.
Using the Format Cells dialog
The Format Cells dialog is where most date reformatting happens. After you select your cells and right-click, the dialog opens to the Number tab by default. On the left side, you will see a list of categories: General, Number, Currency, Date, and others. Click Date.
The middle column shows all the date formats Excel has built in. Scroll through the list and watch the preview at the top of the dialog change as you click each one. The preview shows you exactly how your dates will look. Once you find the one you want, click OK and the change applies to all selected cells at once.
The Locale dropdown at the bottom lets you change the language and regional style. If you choose French, for example, the date formats shift to French conventions. This is useful if you are working with international teams or need dates in a specific language.
Building a custom date format
If none of the preset formats match what you need, click Custom at the bottom of the Category list. You will see a text field labeled Type where you can type a format code. Excel reads these codes to build the date display you want.
The most common codes are d (day), m (month), and y (year). Type them in the order you want. For example, mm/dd/yyyy gives you 01/15/2024. Type mmm d, yyyy to get Jan 15, 2024. Type dddd, mmmm d, yyyy to get Friday, January 15, 2024. The preview updates as you type so you can see the result before you click OK.
You can also add text. Type "Date: " mm/dd/yyyy and Excel will display Date: 01/15/2024. The text in quotes stays exactly as you type it. This is handy when you want a label or note built into the cell display.
Changing dates in a single column at once
If an entire column holds dates you want to reformat, click the column header to select the whole column. Then right-click and choose Format Cells. The same dialog opens, and any format you pick applies to every cell in that column. This is much faster than selecting cells one by one.
Be careful: if the column has other data mixed in — text, numbers, or blank cells — the format still applies to the whole column. Cells that are not dates will not change appearance, but the format is there if you later enter a date into one of those cells.
What happens to the actual date when you reformat
Changing the format does not change the date itself. Excel stores every date as a number behind the scenes. The format just tells Excel how to display that number. If you change a date from 01/15/2024 to January 15, 2024, the cell still holds the same date. If you use that cell in a formula or calculation, Excel uses the real date, not the display format.
This matters because it means you can reformat dates as many times as you want without losing information. You can also copy a formatted date and paste it into another cell, and the format comes with it.
Fixing dates that look like text
Sometimes dates appear as text instead of actual dates. You will notice this if they are left-aligned in the cell instead of right-aligned, or if they do not respond to date formatting. This usually happens when you paste dates from another program or when Excel misreads them on import.
To fix this, select the cells, go to Format Cells, and choose Date from the Category list. Pick a format and click OK. If the dates still look like text, they may need to be converted first. Copy the cells, then use Paste Special (Ctrl+Shift+V on Windows, Cmd+Shift+V on Mac) and choose Values. This sometimes forces Excel to recognize them as dates.
Common date format codes and what they produce
| Code | Example Output | Use Case |
|---|---|---|
| mm/dd/yyyy | 01/15/2024 | Standard US format |
| dd/mm/yyyy | 15/01/2024 | Standard European format |
| mmm d, yyyy | Jan 15, 2024 | Written format, short month |
| mmmm d, yyyy | January 15, 2024 | Written format, full month |
| dddd, mmmm d, yyyy | Friday, January 15, 2024 | Full date with day of week |
| yyyy-mm-dd | 2024-01-15 | ISO standard, sorting |
| d-mmm-yy | 15-Jan-24 | Compact written format |
Frequently Asked Questions
Can I change the date format for just one cell?
Yes. Click the single cell, right-click, choose Format Cells, pick your date format, and click OK. The format applies only to that cell. You can do this for as many individual cells as you need, but selecting a range and formatting them all at once is faster.
What if my dates are showing as numbers like 45000?
That is Excel's internal date storage showing through. Select the cells, open Format Cells, choose Date, pick a format, and click OK. The numbers will display as proper dates. If they do not, the data may not be recognized as dates and may need to be re-entered or converted.
How do I show just the month and year, like "January 2024"?
Open Format Cells, click Custom, and type mmmm yyyy in the Type field. Click OK. The preview will show you the result before you explore it. You can also use mmm yyyy for a shorter version like "Jan 2024".
Does reformatting a date change it in formulas?
No. The actual date stored in the cell stays the same. If you use that cell in a formula or calculation, Excel uses the real date value, not the display format. Formatting only changes how the date looks on screen.
Can I explore a date format to cells that are currently empty?
Yes. Select the empty cells, open Format Cells, choose Date, pick your format, and click OK. When you later type or paste a date into one of those cells, it will automatically display in the format you set.