How to Change Short Date Format in Excel for Dates

To change how dates appear in Excel for Microsoft 365 on Windows, select the date cells, then choose Home > Number Format > Short Date. This changes the display, not the underlying date value. If you need a different pattern, use Format Cells to choose or create a date format.

What You’ll Need

An Excel workbook with date values in the cells you want to format. A date may look like text but not behave like a date, so you may need to convert it first.
Access to the worksheet and permission to change its formatting. If the sheet is protected, you may need the password or help from its owner.
For a format not offered in the Short Date list, the pattern you want, such as 2026-11-02 or 2-Nov-2026.

Step-by-Step

Select the cells containing the dates. Click a single cell to format it, drag across a range, or select a whole column by clicking its letter. To format non-adjacent ranges, hold Ctrl on Windows while selecting each range. If you want future dates entered into a column to use the same display, format the column rather than only the cells currently filled in. Avoid selecting unrelated numbers if you do not want them displayed as dates.
Open the number-format menu. On the ribbon, choose Home. In the Number group, open the Number Format drop-down. Excel may show a current format such as General, Date, or a custom pattern. The drop-down is separate from the font and alignment controls.
Apply Short Date. Choose Short Date from the list. The selected cells should immediately display a compact date, often as a numeric pattern such as 11/2/2026. The exact order and separators depend on your regional settings, so another computer might show the same date as 2/11/2026 or 2026-11-02. Check that the displayed order is clear to the people who will read the workbook.
Use Format Cells for more control. If the preset is not what you need, keep the cells selected and press Ctrl+1 on Windows to open the Format Cells dialog. Select the Number tab, then choose Date. Review the sample and the available date types. If a listed type matches your preference, select it and click OK. The sample helps you see the effect before you apply it.
Create a custom date pattern if needed. In Format Cells, select Custom under Category. Choose a suitable existing pattern or enter one in the Type box, then check the sample and click OK. For example, d/m/yyyy displays a day, month, and four-digit year; mm/dd/yy displays a two-digit month, day, and year; and d-mmm-yyyy displays a day, abbreviated month name, and four-digit year. Use the pattern that suits your audience and avoids ambiguity.
Check the result across the range. Look at dates near the start and end of the selected cells, and confirm that the values still sort in date order and work in any formulas. Formatting changes their appearance, not their stored date values. If a cell shows a row of number signs, widen the column. If the display does not change, check whether the cell contains a real Excel date or text.
Save the workbook. Save after confirming the display is right. If you need the same format in another range, select the destination cells and apply the same number format. For a one-off transfer, Format Painter can copy formatting, but check that it has not also copied other formatting you did not intend to change.

On Mac: The Home tab also contains the number-format controls; select the cells and choose Home > Number Format > Short Date. To open Format Cells, use Command+1 rather than Ctrl+1, or use the Format Cells command from the menus. In Excel for the web: select the cells and use Home > Number Format > Short Date. The available custom-format controls can differ from desktop Excel; if you cannot enter the pattern you need, open the workbook in the desktop app.

Common Mistakes

Expecting formatting to convert text into a date. A date-looking entry imported from a website or CSV may be stored as text. Applying Short Date will not necessarily change it. Check whether the value can be sorted as a date or used in date calculations; if not, convert it before formatting.
Confusing month and day order. A display such as 3/4/2026 can mean March 4 or April 3, depending on the regional pattern. For shared workbooks, consider a less ambiguous custom format such as d-mmm-yyyy, which displays 4-Mar-2026 or 3-Apr-2026.
Using a two-digit year when the century matters. A pattern ending in yy saves space, but it hides the century from the reader. Use yyyy for schedules, historical records, or documents that may be read much later.
Changing the wrong cells. Selecting an entire worksheet or column can also affect numbers that are not dates. If those values suddenly look like dates or become hard to read, undo the change and apply the format to only the intended range.
Assuming Short Date is identical on every computer. Excel’s preset date display can reflect Windows or regional settings. A workbook may therefore look different in another locale, even though the stored dates are the same. Use a suitable custom pattern when consistency is important, and test the workbook in the environment where it will be used.

Tips

Use a readable format for shared files. Numeric dates are compact, but abbreviated month names can reduce confusion across regions. A pattern such as d-mmm-yyyy is usually easier to interpret at a glance than a date with two numbers before the year.
Keep the underlying date intact. If you only want a different appearance, change the cell’s number format rather than replacing the value with typed text. Real date values remain useful for sorting, filtering, calculations, and calendar-based analysis.
Apply a format to an input area in advance. Formatting a whole date-entry column can make future entries consistent. If a table automatically adds rows, check that the new rows inherit the format; if they do not, apply it to those cells too.
Use a custom format to show or hide detail. A format such as mmm yyyy can display only a month and year while the full date remains stored. This is useful for summaries, but remember that dates within the same month can still be different underlying values.
Consider the workbook’s audience and purpose. A compact local Short Date may be convenient for personal tracking, while a clear month-name format can help when a file is circulated internationally. Do not rely on formatting alone to communicate a deadline if an ambiguous display could cause a missed date.

Troubleshooting

The cells do not change after choosing Short Date: Check whether the entries are text. One clue is that changing the alignment or selecting the cell reveals a leading apostrophe, or the values do not behave like dates in sorting and calculations. If the text is consistent, use Data > Text to Columns and follow the prompts to convert it to dates, choosing the correct date order when Excel asks. Make a copy first if the imported values are important. You can also re-enter a value in a recognized date format, but avoid doing this cell by cell for a large dataset.
The date is displayed in the wrong order: The selected Short Date preset follows regional conventions. Open Format Cells and choose a clearer date type or enter a custom pattern with the order you want. If the underlying text has already been converted incorrectly, changing the display will not repair the date; convert the source values again using their actual day-month-year or month-day-year order.
You see number signs instead of a date: Excel often displays #### when the column is too narrow to show the formatted value. Widen the column by dragging the boundary between its column headings, or double-click that boundary to AutoFit the width. If widening does not help, check that the cell does not contain an unexpected negative date or an unsuitable value.
The displayed date differs on another computer: Check that computer’s regional settings and the workbook’s number format. A Short Date preset can render differently across locales. For a more predictable display, use a pattern with an abbreviated month name or a year-first pattern, then check it in the other version of Excel.
The format seems to reset when you enter new data: Confirm that you formatted the cells where new values will go, not just the existing entries. Also check whether a pasted range is bringing its own formatting. Use Paste Special to paste values when appropriate, then apply the intended date format to the destination cells.
The sheet will not let you format the cells: The worksheet may be protected, or the workbook may be opened with restricted editing. Check Review > Unprotect Sheet if you are authorized to do so. You may need the sheet password; do not try to bypass protection if you do not have permission.

Frequently Asked Questions

Does changing the Short Date format change the date itself?
No. It changes how Excel displays a date value. The underlying value remains available for sorting, formulas, and date calculations.

How do I make a date display as day/month/year?
Select the cells, open Format Cells with Ctrl+1 on Windows, choose Number > Custom, and enter d/m/yyyy. Check the sample before clicking OK. On Mac, use Command+1 to open Format Cells.

Can I change Excel’s default Short Date for every workbook?
The Short Date preset can depend on your computer’s regional settings. Changing those settings affects more than one workbook and may affect other apps, so change them only if you want the system-wide date convention changed. For one workbook or range, use a cell format instead.

Why does a date appear as a number after I change its format?
Excel stores recognized dates as serial numbers. If a cell is formatted as General or Number, that stored value may be visible. Apply Short Date or another date format to display it as a calendar date. If the value is not a recognized date, formatting alone will not convert it.

Can I show only the month and year?
Yes. Select the date cells, open Format Cells, and enter mmm yyyy as a custom format. Excel still keeps the full date value, even though the day is not shown.

Will the Short Date format work in Excel for the web?
Yes. Select the cells and choose Home > Number Format > Short Date. If you need a custom pattern that the web app does not offer in its current controls, open the workbook in desktop Excel and set it there.

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.