Google Sheets Keeps Changing Date Format? Here’s Why

Errors & fixes · Updated November 20, 2026

Google Sheets usually changes a date because it automatically recognizes typed or pasted text as a date, or because the cell’s number format or spreadsheet locale controls how that date appears. Select the cells and choose Format > Number > Date or Custom date and time; if you need to preserve characters as text, choose Format > Number > Plain text before entering or pasting them.

What it means when a date changes

A date can seem to change in several different ways. Sheets might turn an entry such as 4/3/2026 into a date, display a date with a different order of month and day, add a time, or show a number instead of a familiar date. These symptoms do not all have the same cause. Often the underlying value is still the same date, but its display format has changed. In other cases, Sheets has interpreted the characters you entered as a different date than you intended.

This distinction matters. A real date in Sheets is a numeric value that can be sorted, compared, and used in calculations. Its number format determines whether it appears as, for example, 4/3/2026, 03-Apr-2026, or April 3, 2026. Text that merely looks like a date is different: Sheets does not treat it as a date for ordinary date calculations. The right fix depends on whether you want a usable date value or an exact text string.

How Sheets recognizes and displays dates

When you type or paste something that resembles a date, Sheets may automatically interpret it as one. The spreadsheet’s locale influences how ambiguous entries are understood. For example, 4/3/2026 can mean April 3 in a month-first convention or 4 March in a day-first convention. If the entry has already been interpreted, changing its display format will not necessarily correct which day it represents.

After recognition, Sheets stores a date as a number and applies a date format to show it in a readable way. That is why changing a date cell to a plain number may reveal a serial value rather than the original characters you typed. It is also why applying a different date format can change the appearance without changing the underlying day. A format such as yyyy-mm-dd is a display choice; it does not, by itself, turn a text string into a date or repair a wrongly interpreted date.

Set a consistent format for existing cells

To make a range display dates consistently in Google Sheets in a web browser:

  1. Select the cells, column, or range you want to change. To format a whole column, click its letter at the top.
  2. Choose Format > Number > Date for a standard date display, or choose Format > Number > Custom date and time to select the order and style of the date parts.
  3. In the custom date and time picker, choose the components and arrangement you need, then apply the format. Check a few cells to confirm that the result is readable and that the dates still represent the intended days.

For example, a column of event dates may be easier to scan as 2026-04-03 than as 4/3/2026, particularly when readers use different regional conventions. A format with the year first also sorts clearly when dates are exported as text, but in the sheet the values remain dates as long as Sheets recognized them as date values. Formatting a whole column can help new entries follow the same display style, although it does not prevent ambiguous text from being interpreted according to the spreadsheet locale.

Check the spreadsheet locale

If dates are being interpreted as the wrong day, inspect the spreadsheet’s locale rather than repeatedly changing the cell display. In Sheets, open File > Settings and check the General settings, including Locale. Locale affects conventions such as date order, decimal separators, and currency defaults. A spreadsheet created for one region may not interpret a short date the way a contributor in another region expects.

Changing the locale can affect how data is interpreted and displayed across the spreadsheet, so do not change it casually in a shared or established file. First confirm which convention the source data uses. For a team that exchanges dates across regions, using an unambiguous entry such as 2026-04-03 in documentation or a controlled import process is safer than relying on 4/3/2026. If the sheet already converted an ambiguous entry, verify the intended date against the original record; a new display format cannot reveal which meaning the person who entered it intended.

Stop formatting from arriving with pasted or imported data

Pasting cells from another spreadsheet can bring along their formatting, so a destination column that looked consistent may suddenly show a different date style. When you want the incoming values but not the source appearance, select the destination and use Edit > Paste special > Values only. Set the destination cells to the desired date format first, then check the pasted results. Values-only paste avoids copying the source cell formatting, but it cannot correct an incorrectly interpreted date value.

CSV imports can create a different problem: a date string may be converted according to the import or spreadsheet locale. When using File > Import, review the import settings and any option to convert text to numbers, dates, and formulas. If the source contains ambiguous dates, confirm the date convention before allowing automatic conversion. Keeping the source column as text can preserve the original strings for review, but you will need to convert them deliberately if you want to sort or calculate with real dates.

For recurring work, make the destination structure part of the process: apply the correct date format to the date column, choose a consistent import convention, and review a few rows after every import. A single unexpected date is easier to spot before the file is shared or used for reporting.

Keep an entry as text when exact characters matter

Some values look like dates but should not function as dates. Examples include an archival label, a date printed on an unverified document, or a code such as 03-04 that must retain its exact characters. Before entering or pasting such data, select the cells and choose Format > Number > Plain text. This tells Sheets to treat subsequent entries as text rather than automatically converting date-like strings.

You can also start a single entry with an apostrophe, such as ’03-04. Sheets uses the apostrophe to indicate text and does not display it as part of the cell value. This is useful for an occasional entry, but it is less convenient than formatting the range as Plain text when importing a full column. If the characters have already been converted to a date, changing the cell to Plain text afterward does not reliably restore the original input. Check the source and re-enter the intended characters as text.

Choose text only when you need to preserve a label or literal string. Text dates may not sort chronologically in the same way as real date values, and date arithmetic will not work on them without conversion. For schedules, deadlines, and logs, a real date with a consistent display format is usually the better choice.

Use date formulas carefully

When a date is assembled from separate year, month, and day values, a date function can avoid ambiguous short-date typing. With no special cell layout required, enter this formula in A2 to create the date March 4, 2026: =DATE(2026,3,4). It returns a real date value; the cell’s number format determines whether the result appears as 3/4/2026, 04-Mar-2026, or another style.

To show a date in a fixed character pattern for a label or export, a text function can format it as text. Assuming A2 contains the real date March 4, 2026, enter this in B2: =TEXT(A2,"yyyy-mm-dd"). The result is the text 2026-03-04. Because it is text, it is useful for display or joining into a label, but it is not a substitute for the original date when you need date calculations. Keep the date value in one cell and use a separate text-formatted result when both purposes matter.

Why dates change after sharing or reopening

In a shared sheet, another editor may paste formatted cells, change a column’s number format, or enter dates using a different regional convention. A date display can therefore vary even when the underlying value remains intact. Agree on a date convention, protect the workflow with a consistently formatted column, and ask collaborators to use unambiguous entries when the intended day could be unclear.

Spreadsheet time zone settings are a separate consideration. In File > Settings, the time zone affects date-and-time values and time-dependent functions such as NOW; it is not the setting that chooses whether a date displays month-first or day-first. Locale controls regional date conventions, while the cell’s number format controls its visual style. Keeping those three roles separate makes troubleshooting much easier.

Frequently Asked Questions

Why does Google Sheets turn 3/4 into a date?

Sheets recognizes many date-like entries automatically. Whether 3/4 is understood as March 4 or 3 April depends on the spreadsheet’s locale. If you mean literal text, set the cell to Format > Number > Plain text before typing, or begin the entry with an apostrophe.

Why did my date change from month/day to day/month?

The spreadsheet locale or the cell’s date display format may use a different order. Check File > Settings for Locale, then select the cells and choose Format > Number to apply the intended display. If the actual day is wrong, verify the source value; changing the format alone will not fix an incorrect interpretation.

How do I stop pasted dates from changing format?

Format the destination range first, then use Edit > Paste special > Values only to avoid bringing over the source formatting. Inspect the pasted dates, especially if the source and destination use different regional conventions, since values-only paste does not prevent ambiguous strings from being interpreted.

Why does a date show as a number in Google Sheets?

The cell may have been formatted as a number or as plain text, or you may be seeing the numeric value Sheets uses to store dates. Select the cell and choose Format > Number > Date. If the result is still unexpected, check whether the value was imported or interpreted incorrectly.

Can I make Google Sheets keep a date as text?

Yes. Select the cells and choose Format > Number > Plain text before entering or pasting the values. For one entry, a leading apostrophe also marks it as text. Remember that text that looks like a date will not behave like a real date in calculations or chronological sorting.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.