Change Date Format in Excel for the Web: Step-by-Step

To change a date’s appearance in Excel for the web, select the date cell or range, open Home > Number Format, and choose Short Date or Long Date. For another display, use More Number Formats and choose a custom format if that option is available. This changes how a real date is displayed, not the date value itself.

Before you start, make sure the cells contain dates Excel recognizes as dates. If a value is stored as text, applying a date format alone will not convert it. The steps below are for Excel for the web in a browser; some menu labels or available custom-format options can vary slightly as Microsoft updates the interface.

What You’ll Need

A workbook open in Excel for the web, with permission to edit it.
The cells, column, or range you want to format. If you are unsure whether the values are real dates, select one and check whether changing its number format affects the display.
A target style in mind, such as 11/2/2026, 2-Nov-2026, or Monday, November 2, 2026. The exact result of a built-in date choice can depend on regional settings.

Step-by-Step

Open the workbook and locate the dates. Sign in to Microsoft 365, open Excel in your browser, and open the workbook. Find the cells that need a different display. If the dates are in a continuous column, you can select the relevant cells together rather than formatting one at a time.
Select the cells you want to change. Click a date cell, or drag across the range. To format a whole column, click its column letter, but do that only if the entire column should use the same date display. Selecting a range that also contains amounts, IDs, or other values can change the display of those cells too, so check the selection before proceeding.
Open the number-format menu. On the ribbon, select the Home tab. Find the Number Format dropdown in the Number area. It may show the current format, such as General, or a number-format symbol. Open the dropdown to see the available formats. Do not confuse this menu with font or cell-color controls; date formatting is a number format.
Choose a built-in date style. Select Short Date for a compact date or Long Date for a date that includes the weekday and written month. The exact order and punctuation can vary by the workbook’s regional settings. For example, a short date may appear as 11/2/2026 in one locale and 2/11/2026 in another. Look at the selected cells after applying the choice to confirm it reads as intended.
Apply a custom display when needed. If the built-in choices do not meet your needs, open Home > Number Format > More Number Formats. In the number-format options, look for a custom category or format-code field. If available, enter or select a pattern such as dd-mmm-yyyy to display 02-Nov-2026, or dddd, mmmm d, yyyy to display Monday, November 2, 2026. Apply the format and inspect the result. If your web version does not offer custom formats, use a built-in style or open the workbook in the Excel desktop app to create the custom format.
Check the result across the full selection. Confirm that each cell shows a plausible date, that the year has not disappeared, and that no values have turned into #### because the column is too narrow. Widen the column by dragging the boundary between its letter headings, or use the column’s resize option if it is available. Formatting can make dates longer without changing the underlying values.
Save and verify the workbook. Excel for the web usually saves changes automatically, but wait for the saving indicator to finish before closing the tab. If the file is shared, remember that the format change is part of the workbook and other editors may see it. Reopen or revisit the sheet if needed to ensure the display persisted.

Common Mistakes

Expecting formatting to convert text into a date. A cell containing text that looks like 11/2/2026 may remain unchanged when you choose Short Date. Excel must recognize the entry as a date value before a date number format can control its display.
Mixing up day and month order. A numeric date such as 04/05/2026 is ambiguous: depending on the locale, it can mean April 5 or May 4. Do not infer the intended date from the display alone when the source data is unclear. Check the source or use an unambiguous style with a written month.
Formatting more cells than intended. Selecting an entire column can affect existing text, numbers, or blank cells in that column. Usually this is harmless for blanks, but numeric values may display unexpectedly. Undo promptly if the wrong range was selected, then select just the date cells.
Typing a display pattern as ordinary cell content. Entering something like dd-mmm-yyyy into a cell does not set its number format; it puts text in the cell. Use the Number Format controls instead.
Assuming the displayed date is a different stored date. A date can look different under another format while its underlying value stays the same. Check the formula bar or use a clear written-month display before concluding that a date changed.

Tips

Use a written month to reduce ambiguity. A format such as 02-Nov-2026 is easier to interpret across regions than 02/11/2026. This is especially useful for schedules, handoffs, and shared workbooks.
Choose a format based on the audience. Short dates save space in a compact report. Long dates are easier to read in a letter or calendar-style list, although they take more room. Keep the year visible in records that may be read later.
Format once, then fill in consistently. If you are building a new date column, apply the desired format to the column or intended range before entering dates. New entries in formatted cells will generally use that display, provided Excel recognizes them as dates.
Keep sorting and calculations in mind. A true date value can still be sorted chronologically and used in date calculations after its display changes. Text that merely resembles a date may sort alphabetically or fail in date calculations, so verify the data type when results seem wrong.
Check regional settings if dates appear in an unexpected order. Excel for the web may provide regional settings under File > Options > Regional Settings. The exact availability can depend on your account and organization. A locale change can affect date presentation and other regional conventions, so consider its impact on the workbook before changing it.

Troubleshooting

The date does not change after choosing Short Date. First select the cell and check whether it is a real date value rather than text. A common clue is that the entry stays exactly the same after you try another number format. If the data came from a download or was entered with an incompatible month/day order, confirm the intended dates before converting anything. You can re-enter a small number of values in a format Excel recognizes, or use Excel’s desktop tools for a larger import; do not blindly convert ambiguous dates because the result could reverse the day and month.

The date changes to a different-looking number. Excel stores dates as numbers and uses number formats to display them. If a cell shows a serial-style number after changing its format, return to Home > Number Format and choose a date option. If it still looks wrong, check whether the cell was actually a date or whether the selected range included other kinds of numbers.

The date shows ####. This usually means the column is too narrow to display the formatted value. Widen the column, or choose a shorter date format. The hashes normally do not mean the date has been deleted.

The date is in the wrong order or month names use another language. Review the workbook’s regional settings and the format you chose. A locale can change how numeric dates are interpreted or displayed. If the data is shared, check with the workbook owner before changing regional settings, because that setting may affect more than one person or other regional conventions in the file.

You cannot find the custom-format option. Excel for the web’s available number-format controls can vary. Try opening More Number Formats from the Number Format dropdown. If there is no custom category or format-code field in your interface, use a built-in format in the browser or open the workbook in desktop Excel, apply the custom number format there, and save it. Avoid replacing dates with text just to force a particular appearance if you still need sorting or date calculations.

Frequently Asked Questions

Does changing the date format change the actual date?

No. Applying Short Date, Long Date, or a custom number format changes the cell’s display. The underlying date value remains the same, so valid date values continue to work for sorting and calculations.

Can I change the date format for a whole column?

Yes. Select the column by clicking its letter, then choose a format from Home > Number Format. Use this for a dedicated date column; if it contains unrelated numbers, select only the date range instead.

Why does the same date look different on another computer?

Excel’s date display can depend on the selected number format and regional settings. A numeric short date is especially easy to interpret differently across locales. A written month, such as 2-Nov-2026, is often clearer when a workbook is shared internationally.

Can I show the weekday as well as the date?

Choose Long Date if its displayed style suits your needs. If you need a particular arrangement, use a custom pattern such as dddd, mmmm d, yyyy where custom number formats are available. The weekday is calculated from the date value; it is not separate text you need to type.

Why does changing the format do nothing to some cells?

Those entries may be stored as text rather than recognized date values. A number format controls how numeric dates appear; it does not automatically parse every text string. Confirm the source’s date order and convert the entries using a suitable import or conversion method before formatting them.

Can I use a custom date format in Excel for the web?

Many Excel for the web interfaces provide custom number formats through More Number Formats, but the controls available can vary. If you cannot enter a custom pattern in your browser, apply the format in the desktop Excel app and save the workbook.

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.