How to Change Date Format in an Excel Column Easily

To change the date format for an Excel column, select the column, press Ctrl+1 on Windows, choose Date or Custom under Number, select a format, and click OK. This changes how valid dates appear, not the dates stored in the cells. If the values are text rather than real Excel dates, convert them first; applying a date format alone will not fix them.

What You’ll Need

An Excel workbook containing the date column you want to format.
A general idea of how you want dates to appear, such as 02/11/2026, 11-Feb-2026, or 2026-02-11.
If the dates came from a text file or another system, the order used in those values, such as month-day-year or day-month-year. This helps Excel interpret them correctly.

Step-by-Step

Check that the cells contain dates. Select one date cell and look at the formula bar. Excel stores real dates as serial numbers, even though the grid shows a calendar date. A quick clue is to temporarily choose Home > Number Format > General. A real date will usually display as a number, often a five-digit value. Restore the date format afterward. If the cell remains text, or the date is left-aligned by default, it may need conversion; alignment alone is not conclusive because a cell may have custom alignment.
Select the cells or the whole column. To format every date in a worksheet column, click its letter heading, such as B. To change only part of the column, drag over the relevant cells or click the first cell and Shift-click the last. If the column contains a heading, selecting the full column is generally fine: Excel leaves ordinary text headings unchanged. If it contains unrelated numbers, consider selecting only the date range so those values are not reformatted.
Open the number-format controls. Press Ctrl+1 on Windows to open the Format Cells dialog. On a Mac, press Command+1. You can also use the ribbon: Home > Number Format dropdown, then choose More Number Formats if that option is shown. In Excel for the web, select the range and use Home > Number Format to choose a standard date style. The desktop Format Cells dialog offers more control over custom formats.
Choose a standard date style. In the Format Cells dialog, open the Number tab and select Date. Choose a format from the Type list and check the Sample preview. For example, a style like 14-Mar-2012 makes the month clear, while a numeric style like 3/14/2012 is compact but can be ambiguous to people who use day-first dates. The list can vary with your regional settings. If there is a Locale or Location option, set it to the convention you need before choosing the type.
Apply the format. Click OK. The selected cells should now display dates in the chosen style. The underlying date value remains the same, so date calculations, sorting, and most date-based formulas continue to work. If the column is too narrow, Excel may show #### instead of the formatted date. Widen the column by double-clicking the boundary between its letter heading and the next one, or drag that boundary to the right.
Use a custom format if the list does not include what you need. Open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, choose Custom under Category, and enter a format in the Type box. For example, dd-mmm-yyyy displays 02-Nov-2026 as 02-Nov-2026; yyyy-mm-dd displays it as 2026-11-02; and mmmm d, yyyy displays it as November 2, 2026. Check the Sample preview, then click OK. In Excel for the web, custom-format options can be more limited; if you cannot enter the needed format, open the workbook in desktop Excel.
Verify the result across the column. Check several rows, including dates near the top and bottom of the selected range. Confirm that the day and month have not been reversed and that blank cells or unrelated values still look as expected. Try sorting the date column from oldest to newest. A correctly stored date column should sort chronologically rather than placing dates in an alphabetical-looking order.

Common Mistakes

Formatting text as though it were a date. Number formats change the display of numeric values, including Excel date serials. They do not automatically turn a text string such as 11/02/2026 into a date value. Convert text dates first, then apply the display format.
Assuming a numeric date is unambiguous. 04/05/2026 can mean April 5 or May 4, depending on regional convention. If the audience may use different conventions, use a month name, such as 05-Apr-2026, or a year-first display such as 2026-04-05.
Confusing formatting with changing the value. Choosing a new format does not move a date forward or backward and does not change its stored day, month, or year. If you need to correct an incorrect date, edit or convert the underlying value rather than just changing its appearance.
Entering a format code as ordinary text. Type codes such as dd-mmm-yyyy into the Custom category in Format Cells, not into the worksheet cell. If you enter the code in a cell, Excel will display the characters instead of using them as a number format.
Applying a date format to mixed data. A column might contain dates alongside text labels, IDs, or amounts. Selecting the entire column can make numeric entries look like dates. Apply the format to the date cells only, or separate mixed data into distinct columns.

Tips

Know the custom-format letters. In Excel date formats, d or dd controls the day, m or mm the month, and yy or yyyy the year. Use mmm for an abbreviated month name and mmmm for the full name. For example, dd mmmm yyyy displays 02 November 2026. The same letter can have different meanings in time formats, so avoid adding time codes unless you need them.
Use four digits for the year. A two-digit year saves space but can be unclear later and may be interpreted according to Excel’s date rules. A format containing yyyy makes the year explicit and is usually safer for reports and shared files.
Keep a consistent format in a working column. Applying the same format to every date makes a list easier to scan and reduces confusion. It does not matter if individual cells were typed using different separators, provided Excel has stored each as a valid date.
Remember that a format is not a text conversion. If you need to send dates to a system that expects literal text in a specific pattern, a number format alone may not guarantee how a CSV export or another application interprets them. Check the destination requirements and inspect the exported file.
Format dates before sharing. Regional settings can affect how short dates are entered and displayed. A style with a spelled-out month is often easier for an international audience to understand than a short numeric date.

Troubleshooting

The cells do not change after you choose a date format. The entries may be text. Try selecting the range and choosing Data > Text to Columns. In the wizard, select Delimited and click Next, then click Next again. Under Column data format, choose Date and select the order that matches the source data, such as MDY, DMY, or YMD. Click Finish, then apply your preferred date format. This process can convert consistently structured text dates. Make a copy of the data first if the values are important, and verify the results because a wrong order can create incorrect dates.

Excel changes the day and month unexpectedly. The source may use a different order from your regional settings. For example, 03/04/2026 could be interpreted as March 4 or April 3. Do not guess based on a few values where both parts are 12 or lower. Check the source system, use Text to Columns with the correct date order, and inspect dates whose day or month is greater than 12 to confirm the interpretation.

You see #### in the cells. This usually means the column is too narrow to show the formatted value. Widen the column or choose a shorter date format. If widening does not help, check whether the cell contains a negative date or time value, which some Excel date systems cannot display as a normal calendar date.

The dates sort in the wrong order. If Excel sorts values alphabetically or groups them oddly, some entries may still be text or the column may contain mixed formats. Convert the text dates, then sort again using the date column. Also check for leading or trailing spaces in imported data and for blank rows that divide the list into separate ranges.

The format looks different on another computer. A built-in Date format can follow the computer’s regional settings. For a more predictable display, use a custom format with a month name or a year-first pattern. The stored value is still a date, but another application may display it according to its own locale or settings.

The custom code is rejected or displays oddly. Check that you entered it under Custom in Format Cells and that the Type box contains a valid pattern such as dd-mmm-yyyy. If Excel uses different regional conventions, the list of built-in examples may differ. Use the Sample preview and test the format on one cell before applying it to a large range.

Frequently Asked Questions

Will changing the date format change the actual date?
No. Formatting changes the way a valid date is displayed, not its stored value. To correct a date that is wrong, edit or convert the cell value itself.

How do I show the month name instead of a number?
Open Format Cells, choose Custom, and use mmm for an abbreviated month or mmmm for the full month name. For example, d mmmm yyyy displays 2 November 2026 as 2 November 2026.

Can I change the date format for an entire column?
Yes. Click the column letter to select the full column, open Format Cells, and choose a date format. If the column contains other numeric data, select only the date cells instead so those values are not displayed as dates.

Why does Excel show a number instead of a date?
Excel may be displaying the date serial value because the cell is set to General or Number. Apply a Date format or a suitable custom format. If it remains a number after formatting, confirm that it is a valid date serial and not an unrelated value.

Can I use YYYY-MM-DD in Excel?
Yes. In Format Cells, select Custom and enter yyyy-mm-dd. This displays a real Excel date in a year-month-day pattern. It changes the display, not the underlying date value.

Does this work in Excel for Mac and Excel for the web?
Yes. Excel for Mac has the Format Cells dialog; Command+1 opens it, while Windows uses Ctrl+1. In Excel for the web, use the Home tab’s Number Format controls for standard choices. If the web version does not offer the custom code you need, use desktop Excel.

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.