How to Change Date Format in Excel on Windows 11

To change how dates appear in Excel on Windows 11, select the date cells, press Ctrl+1, choose a format on the Number tab, and select OK. The change usually affects display only: a real Excel date keeps the same underlying value, so formulas and sorting continue to work. You can choose a built-in format or create a custom one such as 2026-11-02.

Before you begin, check that the entries are actual Excel dates rather than text that only looks like dates. If changing the number format has no visible effect, the cells may contain text; the troubleshooting section explains how to check and convert it. These directions are for the Excel desktop app included with Microsoft 365 on Windows 11.

What You’ll Need

A Windows 11 PC with the Excel desktop app, and a workbook containing the dates you want to format.
Permission to edit the workbook. If the worksheet is protected, you may need its password or an unprotected copy before changing cell formats.
An idea of how you want the dates to look, such as 11/2/2026, 02-Nov-2026, or 2026-11-02. The same date can be displayed in several ways.

Step-by-Step

Open the workbook and identify the date cells. Open the file in Excel and find the cells or column you want to change. Click one date cell to check it, or select a range if you want the same format applied to many dates. To format a whole column, click its letter at the top. Avoid selecting unrelated numbers in the same range, because they will receive the date format too.
Select the cells to format. Drag over a continuous range, or click the first cell and hold Shift while clicking the last cell. For separate ranges, hold Ctrl as you select each one. If the dates are in an Excel table, selecting the date column’s data cells is often safer than selecting the entire worksheet column, because it avoids formatting unrelated cells above or below the table.
Open Format Cells. Press Ctrl+1 on your Windows keyboard. Alternatively, go to Home > Number and open the number-format drop-down, then choose More Number Formats. The Format Cells dialog gives you the built-in date choices and the Custom option. If Ctrl+1 opens a different command, click a worksheet cell first and try again.
Choose a built-in date format. On the Number tab, select Date in the Category list. Look through the Type examples and click the appearance you want. Examples may include a short numeric date, a date with an abbreviated month, or a long date with the full month name. The Sample area previews how a selected cell will look. Choose a locale in the Locale (location) list if you need the month and day order, separators, or month names associated with a particular region.
Apply the selection. Click OK. Excel updates the display of the selected cells; it does not normally rewrite their date values. Check a few cells in the range, particularly dates near the beginning or end, to confirm the whole selection changed. If the result is not what you intended, press Ctrl+Z once to undo the formatting and reopen the dialog with a different choice.
Create a custom format when the built-in choices do not fit. Open Format Cells again with Ctrl+1, choose Custom in the Category list, and enter a format code in the Type box. Click OK to apply it. Useful examples include yyyy-mm-dd for 2026-11-02, d mmmm yyyy for 2 November 2026, and mmm d, yyyy for Nov 2, 2026. Excel may display month names in the language associated with the selected locale.
Understand the code letters before editing them. In date formats, d represents the day, m represents the month, and y represents the year. One or two letters give numeric values with or without a leading zero; three or four letters show abbreviated or full names for days or months. For example, dd/mm/yyyy displays a two-digit day and month with a four-digit year. In formats that also show time, m can mean minutes when it appears in a time context, such as next to h or before s.
Check the result and save the workbook. Click a formatted cell and look at the formula bar. A real date generally appears there as its underlying value, even when the worksheet shows a different arrangement. Review whether the chosen order is clear to other people who will use the file, then save with Ctrl+S. If the workbook is shared internationally, consider a format such as yyyy-mm-dd that makes the order less ambiguous.

A quick alternative is the number-format drop-down in Home > Number. It can apply common formats without opening the full dialog, but the choices shown depend on the current selection and Excel version. Use Format Cells when you need to choose a locale, inspect a preview, or enter a specific custom code.

Common Mistakes

Formatting text instead of dates. A value such as 11/2/2026 may have been imported or entered as text. Applying Date format cannot rearrange text, because Excel is not treating it as a date value. Look for a value that stays unchanged after formatting, or check whether Excel displays a green warning indicator. Use the troubleshooting steps below to convert it.
Confusing day and month order. A value like 04/05/2026 can mean April 5 or May 4, depending on the regional convention. Pick a locale deliberately, and do not assume that another person’s Excel uses the same order as yours. A format with a spelled-out month, such as 5 Apr 2026, is easier to interpret.
Typing a format that includes the wrong letters. For example, mmm shows a shortened month name, while ddd shows a shortened day name. If you use mm in a time format, it may show minutes rather than the month. Start with a known date-only code, check Sample, and add time elements only when you need them.
Expecting a number format to repair invalid entries. Date formatting changes appearance, not the date itself. It cannot decide whether an ambiguous text string means one date or another, or correct a mistyped date. Confirm the intended day, month, and year before converting data.
Formatting too much of the sheet. Selecting a whole worksheet column can also affect totals, notes, or other values that happen to be in that column. Select only the cells that contain dates unless you intentionally want future entries in the column to inherit the format.

Tips

Choose formats for the audience. A numeric format is compact, but can be ambiguous across regions. A format such as 2 Nov 2026 is more readable in a report, while yyyy-mm-dd is useful for files shared across locations or used in chronological lists.
Use a consistent format in each column. Mixed formats can make a worksheet look untidy and make it harder to scan. Select the whole date range and apply one format rather than changing individual cells, unless a particular entry has a good reason to look different.
Keep the original data when converting imported dates. If a conversion requires changing text into date values, make a copy of the column first. That gives you a way to compare results and recover the original strings if Excel interprets an ambiguous date incorrectly.
Remember that display and stored value are different. A cell displayed as Nov 2, 2026 can still contain the same date value as a cell displayed as 11/2/2026. Changing the display format usually preserves date calculations, sorting, and filtering.
Use the Windows regional settings only when appropriate. Windows 11’s Settings > Time & language > Language & region controls regional formats used by Windows and can influence default date conventions. Changing it may affect more than one workbook or app, so use Excel’s Locale (location) setting for a workbook-specific choice where possible.

Troubleshooting

The cell still shows the original text. First check whether the cell is stored as text. Select it and look at the formula bar; if the entry begins with an apostrophe or Excel flags it as text, a number format will not convert it. If Excel recognizes the text as a date, select the affected cells and go to Data > Text to Columns. Choose Delimited and click Next twice without selecting delimiters. In the final step, select Date and choose the order that matches the source data, then click Finish. Try this on a copy first, especially when dates such as 03/04/2026 could be interpreted in two ways.

Excel shows a row of number signs. A cell displaying ###### commonly means the column is too narrow to show the formatted value. Widen the column by dragging the boundary between its column letters, or double-click that boundary to AutoFit the width. The date may be present and correctly formatted even though it is not currently visible.

The date appears as a number such as 46328. Excel stores dates as serial numbers, so this usually means the cell is using General or Number format. Select the cell, press Ctrl+1, choose Date, and pick a display. If applying Date does not produce a plausible date, verify that the number is intended to represent a date and that the source data was imported correctly.

Dates are switching month and day. Reopen Format Cells and select the appropriate Locale (location), then choose a format with the intended order. If the underlying cells contain ambiguous text, changing the display locale alone may not fix the interpretation. Convert those values using the source’s known date order, and check representative entries before applying the conversion to the entire column.

Excel will not let you change the format. The worksheet may be protected, the workbook may be read-only, or the file may be open with editing restricted. Check the Review tab for sheet protection and ask the workbook owner for access if necessary. If the cells are merged or part of a shared workbook setup, try selecting a normal date cell first and check the relevant workbook permissions.

The format changed, but sorting or calculations still behave strangely. That is a sign that some entries may still be text or invalid dates. Sort a copy of the data, inspect the formula bar, and compare a few cells with known calendar dates. Convert text entries only after confirming their intended order; formatting alone cannot make text values behave like dates.

Frequently Asked Questions

Will changing the date format change the actual date?
Usually not. A number format changes how Excel displays a recognized date value; it does not change that stored value. Editing the cell contents or converting text may change the value, so check the formula bar when the underlying date matters.

Can I set a default date format for new workbooks?
Excel does not provide a simple universal setting that forces one date format for every new workbook. You can set a preferred regional format in Windows, format cells in a workbook template, or save a formatted workbook as a template and use it for new files.

How do I show the month name instead of a number?
In Format Cells, choose Custom and enter a code such as mmm d, yyyy for Nov 2, 2026, or d mmmm yyyy for 2 November 2026. Check the Sample preview and the selected locale because month names can be localized.

Can I change the date format in Excel for the web?
Yes. Select the cells and use Home > Number Format to choose an available date format. The web interface and custom-format options can differ from the Windows desktop dialog, so use the desktop app if you need a particular locale or a custom code that is not offered online.

What is the shortcut to open date-format settings?
In Excel for Windows, select the cells and press Ctrl+1 to open Format Cells. On a Mac, the equivalent is Command+1. Windows 11 is the operating system, not a separate Excel edition, so the exact options depend on the Excel app and update channel installed.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.