How to Keep Date Format in Excel

To keep dates consistent in Excel, select the cells or column, open Format Cells, choose a date format, and save the workbook as an Excel file (.xlsx). Set the format before entering or pasting dates when possible. This controls how real Excel dates are displayed; it does not change the underlying date value. Before you start, check whether your entries are true dates or text, because formatting cannot turn text into dates by itself.

What You’ll Need

Excel for Microsoft 365 on Windows, or access to Excel for Mac or the web if that is where you work.
A workbook containing the dates you want to format, or a blank sheet where you can set up the date column first.
The date style you want to use, such as 14-Mar-2026 or 2026-03-14. If you are sharing the file, agree on a style that will be clear to people in other regions.

Step-by-Step

Select the cells that should show dates. Click and drag across the date cells, or click a column letter to select the whole column. If the column has a heading, selecting the whole column is usually fine; the heading text will remain text. To format several separate areas, hold Ctrl on Windows while selecting each range. On a Mac, hold Command while selecting additional ranges. You can also select a range first and then extend it with Shift-click.
Open the cell-format settings. In Excel for Microsoft 365 on Windows, press Ctrl+1 to open Format Cells. On a Mac, press Command+1. Alternatively, use Home > Number Format and choose More Number Formats, or open the dialog launcher in the Number group on the Home tab. These settings apply to the selected cells, not automatically to every date elsewhere in the workbook.
Choose a built-in date display. In the Format Cells dialog, select the Number tab and choose Date. Review the examples in the Type list and pick a format that makes the order of day, month, and year obvious. For example, 14-Mar-2026 is less ambiguous internationally than 03/14/2026. The Sample area previews how an existing date will appear. Click OK to apply the format.
Set the format before adding new dates. If the column is blank, select it and apply the date format before typing or pasting values. Then enter dates consistently, preferably with a four-digit year. A month name, such as 14 Mar 2026, can help avoid confusion when Excel interprets entries according to regional settings. Excel still decides whether an entry is a date based on its value and your settings; the display format controls how a recognized date looks.
Use a custom format if the built-in choices do not fit. In Format Cells, choose Custom and select an existing pattern or enter one in the Type box. For example, dd-mmm-yyyy displays a date as 14-Mar-2026, while yyyy-mm-dd displays it as 2026-03-14. Use mmm for an abbreviated month name and mmmm for the full month name. Click OK, then check a few cells to confirm that the order and appearance are what you intended.
Paste dates without bringing unwanted formatting along. A normal paste can copy the source cells’ number formats, so the destination may change even if you formatted it first. If you need the destination’s existing format, copy the source cells, then use Home > Paste > Paste Special > Values. This pastes the cell values without the source formatting. Check the result afterward: if the pasted values are text rather than real dates, apply the conversion steps in Troubleshooting before relying on date sorting or calculations.
Save and verify the workbook. Save in Excel Workbook format (.xlsx) to retain cell formatting, close the file, and reopen it to confirm that the dates still display as expected. If you are working in Excel for the web, built-in date formats are available from the Home tab’s Number Format menu; options for creating or editing custom formats can vary. Open the workbook in desktop Excel if you cannot find the custom format control you need. On a Mac, the Format Cells dialog has the same main Date and Custom choices, though the ribbon layout may differ slightly.

For a column that will grow over time, format the full column or create an Excel table before adding new rows. Table columns often carry number formatting into new rows, but check a newly added date rather than assuming the format continued. If you later paste from another workbook, repeat the check because pasted formatting can override the destination’s display.

Common Mistakes

Assuming a number is broken because it looks like 46000. Excel stores dates as serial numbers, so a cell formatted as General may show a number instead of a calendar date. If the value is a valid date serial, changing the Number Format to Date will display it as a date. The serial itself is not the date style; it is the stored value.

Formatting text and expecting Excel to convert it. A value such as an apostrophe-prefixed date, or text imported from another system, can look like a date while remaining text. Applying a date format to text usually has no visible effect. Convert the value to a real date first, then choose its display format.

Mixing up day and month order. An entry such as 04/05/2026 could mean April 5 or May 4, depending on the regional convention used when Excel reads it. A date format changes the display but cannot reliably correct a value that Excel interpreted the wrong way. Use an unambiguous entry or specify the correct locale during import.

Saving a formatted sheet as CSV and expecting the style to remain. CSV files do not retain Excel cell formats, formulas, or workbook structure. Excel may show a date in a different way when the CSV is opened again, or another application may interpret it using different regional settings. Keep an .xlsx copy when you need to preserve the workbook’s formatting.

Tips

Choose a format that makes the year visible in records that may be kept for several years. A two-digit year can be harder to interpret later.
For shared workbooks, prefer a month name or an unambiguous year-month-day display over a numeric day/month pattern. This reduces confusion when colleagues use different regional settings.
Apply formatting to the intended date range, not just one example cell. If you format a whole column, avoid applying the style to unrelated data that may be entered there later.
Use the Sample preview in Format Cells to check the result before applying a custom pattern. If a custom code is unfamiliar, test it on a few sample cells first.
Keep a working copy in .xlsx format before exporting, importing, or making broad formatting changes. That gives you a version with the original values and formats to return to if an operation changes them.

Troubleshooting

The cell still shows the original text after formatting. First check whether Excel recognizes the value as a date. A common sign that it is text is that it stays unchanged when you switch between General and Date formats, or that it is aligned like other text entries. For a small number of cells, re-enter the value in a form Excel recognizes, such as 14 Mar 2026, then apply the desired format. For a larger range, select the cells and use Data > Text to Columns. In the wizard, proceed to Step 3, choose Date, select the order that matches the source data, and finish. Check several converted cells against the original source before using the results.

The date displays as a number. Select the cell and choose Home > Number Format > Short Date, or open Format Cells and select a Date option. If it continues to show a number, check that the format change was applied to the correct cell and that the cell is not being displayed through a formula or imported text. A valid date serial should change appearance when you apply a date format.

The day and month appear reversed. Changing the display pattern may make the stored date easier to read, but it will not repair an incorrectly interpreted entry. Compare the cell’s value with the original source. If you are importing a CSV, use Data > From Text/CSV and review the preview rather than opening the file by double-clicking. In Power Query, select the date column and use Transform > Data Type > Using Locale to choose the locale that matches the source. Confirm the result before loading it into the worksheet.

New rows do not keep the format. Select the new cells and apply the date format again. If the dates are in an Excel table, add a row within the table or check the table’s date column formatting. Pasting a whole row from another source may replace the table’s formatting, so paste values when appropriate and inspect the new row.

The format changes after sharing or exporting. Confirm that you saved as .xlsx if the recipient needs Excel’s cell formatting. For a CSV handoff, remember that the receiving program controls how it reads and displays the date text. Include a clear note about the intended order, or provide an .xlsx copy alongside the CSV when preserving the visual format matters.

Frequently Asked Questions

Why does Excel change the date format when I type?
Excel may apply a default date style based on your regional settings or on the formatting already used in the column. Select the cells and choose the desired format through Format Cells. For consistent future entries, format the column before entering dates.

Does changing the date format change the actual date?
No. Number formatting changes how a recognized date value is displayed, not the underlying value. If Excel interpreted an ambiguous entry as the wrong day and month, changing the format alone will not correct it.

Can I keep the same date format in every workbook?
You can set a preferred format in a workbook template and start new files from that template. Excel’s default date display can also depend on your operating system’s regional settings, so a template is often the more predictable choice for a particular work process.

Why does a date become a number when I paste it?
Excel stores dates as serial numbers. The pasted value may have arrived with General formatting, so select the cells and apply a Date format. If changing the format does not help, the pasted content may be text and needs conversion.

Will an Excel date format survive a CSV export?
No. CSV preserves plain data, not Excel number formats. Keep an .xlsx version if the workbook’s display formatting must be retained, and check a CSV in the application that will receive it.

Can I use custom date formats in Excel for the web?
Excel for the web provides built-in number formats, but custom-format controls may differ from desktop Excel and can depend on the current version. If you cannot create or edit the required pattern in the browser, open the workbook in Excel for Windows or Mac and set it in Format Cells.

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.