Change Date Format in Excel Cells: A Step-by-Step Guide

To change how a date appears in an Excel cell, select the cell or range, press Ctrl+1 on Windows, choose a format on the Number tab, and select OK. This changes the date’s display, not the date value itself. Before starting, make sure Excel recognizes the entries as dates; formatting cannot turn ordinary text into real dates.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows.
The cells containing the dates you want to display differently. Select a range to change several cells at once.
A preferred date style, such as 11/2/2026, 2-Nov-2026, or 2026-11-02. If dates must follow a particular country’s convention, know the relevant locale.

Step-by-Step

Select the date cell or cells. Click one cell to change just that date’s display. To format a continuous block, click the first cell and drag to the last, or click the first cell and hold Shift while clicking the last. You can also select an entire column by clicking its letter, but consider whether non-date values in that column should receive the same format. To select separate cells, hold Ctrl as you click each one.
Open Format Cells. Press Ctrl+1 on Windows. Alternatively, right-click the selection and choose Format Cells. In the dialog, open the Number tab if it is not already selected. The keyboard shortcut opens the same dialog on the selected cells; it does not change any values by itself.
Choose a built-in date category. Under Category, select Date. Review the available examples in the Type list and the Sample preview. Click a style that fits your needs. For instance, a short numeric style is compact, while a style that includes a month name can make dates easier to scan and reduce confusion between day and month.
Check the locale when the order matters. In the Date category, use the Locale (location) list to choose the regional convention you need, then pick a Type. This matters when a date could be read differently in different countries: 04/05/2026 may mean April 5 or May 4. Choose the locale that matches the intended display and confirm that the Sample preview shows the day and month in the right order. A display choice does not resolve an incorrectly interpreted source date, so check the underlying date too when the original entry was ambiguous.
Use a custom format if none of the built-in styles is suitable. In the Format Cells dialog, select Custom under Category. Click an existing format in the Type box and replace it with a pattern such as yyyy-mm-dd for 2026-11-02, dd-mmm-yyyy for 02-Nov-2026, or mmmm d, yyyy for November 2, 2026. Read the Sample preview before applying the pattern. Custom formats specify how an actual date value is displayed; they are not formulas and do not rewrite the date.
Apply the format. Click OK. Look at the selected cells and confirm that the displayed dates have the desired order, separators, and level of detail. If the result is not right, press Ctrl+1 again, select another Type, or edit the custom pattern. The change applies to every selected cell, so review the whole range rather than just its first value.
Use the ribbon for a quick built-in style, if appropriate. With the cells selected, go to Home > Number Format and choose Short Date or Long Date from the dropdown. The exact date appearance can depend on regional settings. Choose More Number Formats to open the Format Cells dialog when you need a specific pattern or locale. In Excel for Mac, Command+1 opens Format Cells; the ribbon options are also on the Home tab. In Excel for the web, select the cells and use the Number Format dropdown on Home. The web version offers common options, while the desktop dialog may provide more detailed custom-format controls.

Custom date codes are made from letters that represent parts of a date. In a format such as dd/mm/yyyy, dd displays a two-digit day, mm a two-digit month, and yyyy a four-digit year. Use d for a day without a leading zero, mmm for an abbreviated month name, and mmmm for a full month name. For example, d mmmm yyyy can display 2 November 2026. The slash in a format may appear according to your regional date separator. In a date-only pattern, mm means month; in a time pattern near hours or seconds, m can represent minutes. If the preview looks unexpected, check the surrounding date or time codes.

Common Mistakes

Formatting text and expecting it to become a date. A cell may contain characters that look like a date but are stored as text. Applying a date format only changes the display of recognized numeric date values, so text may remain unchanged. Check alignment and try changing the number format back to General; a genuine date typically appears as a serial number under General.
Assuming the format fixes an ambiguous entry. If Excel interpreted 04/05/2026 using the wrong regional convention when it was entered, choosing a different display pattern will not necessarily change which day and month the value represents. Check the intended date before using the result in calculations or reports.
Typing a format into the worksheet instead of the Type box. The pattern belongs in Format Cells > Number > Custom > Type. Entering it into the cell replaces the date with text rather than setting the cell’s number format.
Using two-digit years when the century must be clear. A display such as 02-Nov-26 is shorter, but readers may not know which century is intended. Use yyyy for records, schedules, or exported data where the full year matters.
Formatting a whole column without checking its contents. A date format applied to a column may affect IDs, notes, or other numbers in that column. Select only the date cells when the column contains mixed data.

Tips

Choose a format for the reader. A short numeric format saves space in a dense table, but a month name can be clearer in a report used across regions. A pattern such as dd-mmm-yyyy makes the month explicit while keeping the date compact.
Keep real dates as dates. Date values can be sorted chronologically, used in date calculations, and displayed in multiple formats without changing the underlying value. Avoid converting them to text just to make them look a certain way unless a downstream system specifically requires text.
Copy a format without replacing the date. Use Format Painter on the Home tab to copy a cell’s formatting to other cells. You can also copy a correctly formatted cell, select the destination, and use Paste Special > Formats. Check that the destination cells actually contain dates; applying a date style to unrelated numbers can make them appear as unexpected dates.
Use the preview as a check. The Sample box shows how the selected value will appear in the chosen format. If it shows an unexpected date, inspect the cell’s stored value and locale before applying the format to a large range.
Remember that formatting is not the same as entering a date. Excel stores recognized dates as serial values, so one cell can show 2-Nov-2026 while another displays 11/02/2026 even when both represent the same date. This is useful for presentation and does not change date-based sorting or arithmetic.

Troubleshooting

The display does not change after selecting a date format. The entry may be text. Select the cell and look for an apostrophe in the formula bar or a warning indicator; either can suggest that Excel is treating the value as text. For a single entry, edit it and enter it again in a date form Excel recognizes, then apply the display format. For a column of consistently structured text dates, select the cells and choose Data > Text to Columns. Follow the wizard, set the column data format to Date, choose the source order such as MDY or DMY, and finish. Make a copy first if the data is important, and verify a few converted dates because the correct order depends on how the source text was written.

The cell shows a number such as 46328. That is likely the date’s underlying serial value displayed with General formatting. Select the cell, press Ctrl+1, choose Date, and apply a date style. If the serial is not the date you expected, check whether the original value was entered or converted correctly.

The cell shows #####. Excel may not have enough column width to display the formatted date. Widen the column by dragging the boundary to the right of its heading, or double-click that boundary to AutoFit. If widening does not help, check for a negative date or time value; Excel’s default date system cannot display negative date-time values as ordinary dates.

The day and month appear reversed. Confirm the intended date and the source order before changing anything. If importing text, use Text to Columns and select the matching date order. If the value is already a real date but only needs a different display, choose the correct locale or use an unambiguous format such as yyyy-mm-dd. Do not rely on a format change alone to correct a value that Excel interpreted incorrectly.

A custom format is rejected or looks wrong. In Format Cells > Number > Custom, use a supported pattern and check its preview. Make sure the pattern is in the Type box and not the worksheet cell. For a plain date, start with dd-mmm-yyyy or yyyy-mm-dd, then adjust it. Regional settings can affect separators and month-name language, so the preview is the best immediate check.

Frequently Asked Questions

Does changing the date format change the date itself?
No. It changes how Excel displays a recognized date value. The underlying value remains available for sorting, calculations, and other date formats. If the stored date was interpreted incorrectly on entry, correct the value separately.

How do I make Excel show the month name?
Select the cells, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, and choose Custom. Enter dd-mmm-yyyy for an abbreviated month, such as 02-Nov-2026, or mmmm d, yyyy for a full month name, such as November 2, 2026. Check the Sample preview and click OK.

Can I change the date format for a whole column?
Yes. Click the column letter to select it, then apply a built-in or custom date format. If the column includes values that are not dates, select only the relevant cells instead; otherwise those other values may display unexpectedly.

Why does Excel show a different date than the one I typed?
Excel may have interpreted the entry using a different regional order for day and month, or the entry may have been imported as text. Check the intended date and how the source is structured. For text imports, use Text to Columns with the correct date order, then verify the converted values before applying a display format.

Can I make Excel use this date format automatically for new entries?
You can format an existing range or an entire date column in advance; new dates entered into already formatted cells will generally use that cell format. For a growing list, an Excel Table can extend formatting as rows are added. Always check a newly entered value, because pasted content may bring its own formatting or may be stored as text.

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.