Change Date Format in Google Sheets: Steps and Fixes

To change a date’s appearance in Google Sheets, select the date cells and choose Format > Number, then pick a date style. For a different pattern, open Format > Number > Custom date and time, choose or enter the format you want, and click Apply. This changes how a recognized date is displayed, not the date value itself.

Quick steps to change a date format

In Google Sheets in a web browser, formatting can be applied to one cell, a selected range, or an entire column. To format a range, drag across its cells or click the first cell and Shift-click the last. To select a whole column, click its letter at the top of the grid. Then:

Open the Format menu.
Choose Number.
Select a built-in date format, or choose Custom date and time to build a specific pattern.
If using a custom pattern, select the date and time components shown in the dialog, arrange them as needed, and click Apply.

For example, a date displayed as 12/31/2025 can be shown as Dec 31, 2025 or 2025-12-31 without changing the underlying date. The exact built-in choices can vary with the spreadsheet’s locale. If the result is not what you expected, first check whether the cell contains a real date value rather than text.

What a date format changes—and what it does not

Google Sheets stores recognized dates as date values, which can be used in calculations, sorting, and date-based functions. A number format controls how that value appears in the grid. For instance, the same date might display as 3/4/2026, 04-Mar-2026, or Wednesday, March 4, 2026. Those are different presentations of one value, not three different dates.

This distinction matters when sharing or exporting a sheet. Changing a cell’s format generally does not rewrite the date, so formulas that use it continue to refer to the same value. It also means formatting cannot fix a date that Sheets has stored as ordinary text. Text may look exactly like a date on screen but fail to sort chronologically or work correctly in date calculations.

A date-time value can include a time as well as a date. A date-only format may hide the time portion while leaving it in the cell. If two entries appear to be the same date but behave differently in a calculation, one may contain a time that is not visible under the selected format.

Choose a format that suits the sheet

The best date pattern depends on who will read the spreadsheet and what the dates are used for. A compact format is useful in a narrow report, while a month written as a word can make dates easier to interpret in a document shared across regions. Consider these common choices:

12/31/2025: compact, but readers may not know whether the first number means month or day.
31/12/2025: familiar in many regions, but potentially ambiguous to readers used to month-first dates.
Dec 31, 2025: clear for many English-language audiences, though the month abbreviation is language-dependent.
2025-12-31: a year-first layout that is useful in data tables and reduces day-month ambiguity.
Wednesday, December 31, 2025: descriptive, but takes more space and can be inconvenient in dense tables.

For records exchanged between people in different countries, a written month or year-first layout can reduce confusion. If a date has legal, operational, or business significance, confirm that the chosen display convention is understood by everyone who receives the file; formatting alone does not communicate every regional assumption.

Build a custom date pattern

Choose Format > Number > Custom date and time to use a pattern that is not listed among the standard options. The dialog lets you assemble date and time parts, change their order, and adjust elements such as whether a month is numeric or written out. For a simple year-month-day display, select the year, month, and day components in that order and use separators that make the result readable.

In custom date patterns, the letters represent date or time components: day, month, and year are commonly represented by d, m, and y. Repeating a component can affect how much detail appears; for example, a numeric month differs from a month written as a name. The dialog provides selectable components, so use its preview to confirm the result instead of relying on a pattern copied from another spreadsheet program. In date-time patterns, the meaning of m can depend on context: it can mean month in a date portion or minute in a time portion.

Custom patterns are useful when a report needs a consistent display such as a four-digit year or abbreviated month. They do not change the spreadsheet’s locale, and they do not convert text into dates. If you are building a format for a shared sheet, check the preview and test it on a few representative cells before applying it to a large range.

Locale, regional settings, and date interpretation

A spreadsheet’s locale influences default date, number, and currency conventions, as well as how Sheets interprets many typed or imported values. To review it, open File > Settings and check the General section’s Locale setting. Changing the locale can affect the spreadsheet more broadly than changing one column’s number format, so review other regional conventions before saving a change.

Display and interpretation are related but separate. Applying a custom format tells Sheets how to show a value it already recognizes as a date. Locale helps determine how an input such as 04/05/2026 is interpreted when entered or imported. Depending on the convention, that text could mean April 5 or May 4. A format change after entry will not reliably correct a value that was interpreted as the wrong day and month; verify the intended date and correct the data itself if needed.

Time zone settings are another distinct issue. A date format controls visible components, whereas time zone settings can matter for time-based values and functions. If a timestamp appears shifted, changing the date pattern is not necessarily the solution. Check the spreadsheet’s settings and the source of the timestamp as well.

Why changing the format may not work

If the display does not change after choosing a date format, the most common explanation is that the cell contains text rather than a date value. Imported CSV files, pasted data, and dates written in an unfamiliar regional order can all produce text that resembles a date. A custom date format will not turn that text into a date by itself.

For text that Sheets recognizes under the spreadsheet’s locale, the DATEVALUE function can convert a date string to a date value. For example, if A2 contains the text 2025-12-31 and the spreadsheet recognizes that year-first date, enter this in B2: =DATEVALUE(A2). The result represents December 31, 2025; apply a date number format to B2 if it displays as a number. If Sheets cannot interpret the text, check its locale and the source format rather than assuming the conversion succeeded.

Other common causes of confusing results include:

Wrong cells selected: confirm the intended range is highlighted before applying the format.
A time is hidden: use a date-time format temporarily to see whether the value includes hours or minutes.
Mixed data in one column: some rows may contain true dates while others contain text or blanks.
Ambiguous imported dates: verify the actual day and month against the source before converting or sorting.
An unexpected locale: check File > Settings rather than repeatedly changing the display format.

When a column contains mixed types, formatting the whole column can make recognized dates look consistent while leaving text entries unchanged. That inconsistency is a clue that the data needs cleanup, not just another display pattern.

Apply formats consistently and avoid surprises

For a column that will receive new dates later, select the column and apply the desired date format before entering data. This can help keep the display consistent, though it does not guarantee that pasted or imported text will be converted into date values. After importing, check a few cells and test whether the dates sort in chronological order.

To change the appearance throughout a workbook, handle each relevant sheet and range deliberately. A date format applied to one range does not automatically establish a universal preference for every existing cell in every tab. If a sheet is used as a template, keep a clearly formatted example row and communicate the expected date convention to people entering data.

Google Sheets also has a currency and number-formatting system in the same Format > Number menu. Be careful not to choose a general number format when the goal is a date display. If a date suddenly appears as a large number, the value may still be intact; reapply a date format to show it as a calendar date.

Google Sheets compared with Excel

The basic idea is similar in Google Sheets and Microsoft Excel: a date value can have different number formats without changing the stored value. However, menu names, dialogs, shortcuts, and some custom-format behaviors differ. This guide uses Google Sheets in a web browser: its relevant path is Format > Number, followed by a date choice or Custom date and time. In Excel, date formats are selected through the Home tab’s number-format controls, and custom formats are managed through the Format Cells dialog.

Do not assume that a custom pattern copied from Excel will behave identically in Sheets, particularly when it includes times or regional conventions. If a workbook moves between the two products, inspect important date columns after conversion or import. For routine collaboration within Google Sheets, use the Sheets format controls and verify the displayed result in the actual file.

Frequently Asked Questions

How do I change the date format for an entire column in Google Sheets?

Click the column letter to select the column, then choose Format > Number and select a date style or Custom date and time. Existing text entries may not change because they are not stored as date values.

Can I change the default date format in Google Sheets?

There is no single date display choice that automatically reformats every existing cell in every spreadsheet. You can set a spreadsheet’s locale in File > Settings, which affects regional conventions, and format relevant ranges or template cells as needed.

Why does Google Sheets show a number instead of a date?

The cell may be showing the numeric date value because it has a number format rather than a date format. Select it and choose a date style under Format > Number. If that does not help, check whether the contents are text.

How can I display the month name instead of a number?

Select the date cells, open Format > Number > Custom date and time, and choose a month component that displays a name. Use the dialog preview to distinguish an abbreviated month from a full month name.

Will changing the date format change the date itself?

No. Formatting normally changes the display, not the underlying date value. If a date was entered or imported with the wrong day and month, correct the value itself; changing its format only changes how that value is shown.

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.