Google Sheets Date Format Not Changing? Fixes

If a date format in Google Sheets is not changing, the cell may contain text rather than a real date, or the format may be applied to the wrong cells. Select the cells and use Format > Number to choose a date style; if that has no effect, check the cell contents and the spreadsheet locale before trying to convert the values.

Why changing the format sometimes does nothing

Google Sheets stores a real date as a numeric value and displays it according to a chosen number format. The underlying value represents a day; a time can be represented as a fraction of a day. For example, one cell can show the same date as 3/15/2025, Mar 15, 2025, or 15 March 2025 without changing the date itself. Formatting changes how the value looks, not what date it represents.

Text that merely looks like a date is different. A cell containing the characters 15/03/2025 may be treated as text, especially if it was pasted from a website, imported from a CSV, or entered using a pattern that does not match the spreadsheet’s locale. Applying a date format cannot turn those characters into a date value. The text may remain unchanged, align like other text, or fail to behave like a date in sorting and calculations.

Other causes are less obvious: the selection may not include the cells you are inspecting; a formula may be returning text; or the selected cells may have a custom format that displays an unexpected result. Identifying which case applies is quicker than repeatedly choosing different date styles.

Check whether the cell contains a date or text

Start with a cell that is not displaying as expected. Look at the formula bar and try changing its format to a plain number using Format > Number > Number. A real date will appear as a serial number, while a text date usually remains a string. Switch back to a date format afterward. This is a useful diagnostic, not a conversion step.

You can also test whether the value can be used in a date calculation. For example, enter a simple subtraction using the suspect cell and a known date in another cell. If Sheets treats both as dates, the calculation should return a numeric difference. A calculation error or an unchanged text result is a clue that the suspect value needs conversion. Check whether the cell contains a leading apostrophe or spaces as well; either can make an otherwise date-like entry behave as text.

Likely a real date: switching to Number shows a numeric value, and date arithmetic works.
Likely text: the visible characters stay the same under number formatting, or date calculations do not recognize the value.
Likely a selection issue: some cells change while the specific cell you are checking does not.

These checks are not a substitute for understanding the source data. A number can be numeric without representing a date, and a text value can look perfectly plausible. Confirm the intended day, month, and year before converting a whole column.

Apply a built-in date format to the right cells

To format dates that are already stored as date values, select the cells or the entire column, then choose Format > Number > Date. For a different presentation, use Format > Number and choose another available date option. The exact styles shown can vary with the spreadsheet’s locale. Formatting a full column can help keep later entries consistent, but it does not automatically convert existing text values.

For a specific pattern, select the cells and choose Format > Number > Custom date and time. Use the controls in the dialog to assemble a pattern such as a day, abbreviated month, and four-digit year. A pattern like 15 Mar 2025 is easier to read in a report than a numeric date, while 2025-03-15 can be useful for sorting or copying into systems that expect year-month-day. Check the preview in the dialog before applying the custom format.

If only part of the selection changes, inspect the selection again. Click a cell and check the name box to confirm its address, or select the column by clicking its letter. Also check whether the sheet or cells are protected if editing or formatting controls are unavailable. A format setting affects the selected cells, not every cell that happens to contain a similar-looking date elsewhere in the file.

Convert text dates into real dates

When a value is text, it must be converted before date formatting can control its appearance. For a text date that Google Sheets recognizes under the spreadsheet’s current locale, use DATEVALUE in a helper column. With the text date in A2, enter =DATEVALUE(A2) in B2. If A2 contains 15/03/2025 and the locale recognizes day/month/year, B2 becomes a real date for March 15, 2025. Format B2 as a date, then fill the formula down for the other rows.

DATEVALUE depends on whether Sheets can interpret the input. If it returns an error, do not assume the date is invalid: the source pattern may be ambiguous or incompatible with the locale. For example, 04/05/2025 could mean April 5 or May 4. Confirm the source convention first, then adjust the locale or use a conversion method that explicitly separates the year, month, and day. Avoid converting a column until you have checked representative entries and any unusual cases.

Once the converted dates look correct, you can keep the helper formulas or copy the results and use Edit > Paste special > Values only to replace them with fixed values. Keep the original column until you have verified the results, especially when the data is important. If the input includes timestamps or mixed formats, conversion may need additional cleanup rather than one DATEVALUE formula for every row.

Check locale and ambiguous date order

A spreadsheet’s locale influences how dates are interpreted and which date styles appear by default. In Google Sheets, open File > Settings and check the Locale setting. If the spreadsheet receives dates in day/month/year order but is set to a locale that expects month/day/year, a value may be misunderstood or stored as text. Choose a locale appropriate for the data, save the settings, and then review the affected cells. Changing locale can affect date, number, and currency conventions, so check other data in the file too.

Formatting and interpretation are separate operations. Changing the locale can help Sheets parse future entries or values being converted, but it does not guarantee that every existing text string will become a real date. Nor does choosing a display format resolve ambiguity: a stored date for May 4 will remain May 4 whether it is displayed as 5/4 or 4/5. Confirm the intended order with the data source rather than guessing from the cell’s appearance.

Also review the spreadsheet time zone under File > Settings if the values include times or timestamps imported from another system. A time-zone difference can affect how a timestamp is represented or displayed. It is not usually the explanation when a plain date refuses to respond to a number format, so first determine whether the value is text and whether the correct cells are selected.

Look for formulas and imported data that return text

A formula can display something date-like while returning text. A common example is a formula that uses TEXT to create a formatted string. The result may look like a date, but changing the cell’s number format will not change a string produced by the formula. If you need a usable date for sorting or calculations, keep a real date value in the formula and apply the display format to the cell instead of converting the result to text.

Imported data can have the same issue. CSV files and copied web tables may contain dates as strings, leading spaces, unusual separators, or mixed conventions. Check a few cells from the beginning, middle, and end of the column; one clean row does not prove the entire column is consistent. If an import dialog offers an option to convert text to numbers, dates, and formulas, review that setting and still verify the imported results afterward.

Conditional formatting is another possible source of confusion. It can change text or background color based on rules, but it does not convert text into a date or replace the number format. If a date appears visually different only in certain rows, inspect Format > Conditional formatting as well as Format > Number. These controls solve different problems.

A practical troubleshooting order

Use this order to narrow down the cause without changing the data more than necessary:

Select one problem cell and choose Format > Number > Date. Confirm that the intended cell is selected.
Temporarily choose Format > Number > Number. If a numeric serial appears, the value is likely a real date; if the original characters remain, investigate text conversion.
Check the formula bar for a leading apostrophe, spaces, or a formula that returns a string. Compare with a cell that formats correctly.
Review File > Settings > Locale and confirm the date order used by the source data. Treat ambiguous dates as unverified until you know what they mean.
Convert a small sample in a helper column, apply a date format, and check the results before filling down or replacing original data.

This sequence separates three different questions: whether the value is a date, whether Sheets interpreted its parts correctly, and how the date should be displayed. Solving them in that order helps avoid a misleading fix, such as making a wrongly interpreted date look polished without correcting its underlying value.

How this differs from Excel

The core distinction is similar in Google Sheets and Excel: number formatting changes the display of a real date, but it does not reliably turn arbitrary text into a date. The menus differ. In Google Sheets, use Format > Number; in Excel for Microsoft 365 on Windows, select the cells and use Home > Number Format. Excel also has its own regional settings and import behavior, so instructions for converting text in one program should not automatically be assumed to match the other.

If a workbook is shared between Sheets and Excel, check dates after converting or exporting it. Both programs can display the same underlying date differently according to format and regional conventions. A format that looks clear in one locale may be ambiguous to someone using another, so a month name or an unambiguous year-month-day display can help when exchanging data.

Frequently Asked Questions

Why does Google Sheets keep showing a date as a number?
A real date is stored as a number, so the cell may be set to a number format instead of a date format. Select it and choose Format > Number > Date. If it still appears as a number, check that you selected the correct cell and that a custom format is not being applied.

Why does changing the date format not change the value?
Number formatting changes only how a real date is displayed; it does not change the underlying day. If the cell contains text, the format cannot convert it. Use a conversion method such as DATEVALUE when the text is recognized, then format the converted value.

How do I change dates from MM/DD/YYYY to DD/MM/YYYY?
If the cells contain real dates, select them and choose Format > Number > Custom date and time to choose the desired display order. If they are text, confirm what each date means and convert it first. Changing the display order does not safely resolve ambiguous text such as 04/05/2025.

Will changing the spreadsheet locale fix existing dates?
It may help Sheets interpret entries or text converted afterward, but it does not automatically repair every existing text value. Review existing cells and convert them if needed. Changing locale can also affect number and currency conventions in the spreadsheet.

Why does a formula-generated date ignore formatting?
The formula may return text rather than a date value, especially if it uses TEXT to create a display string. Use a formula that returns a date value when you need sorting or date arithmetic, then apply a number format to the result cell.

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.