Remove Date Format in Google Sheets Without Changing Values

To remove a date display in Google Sheets, select the affected cells and choose Format > Number > Number. This changes how the stored values appear, not the underlying date values. If you want future entries to stay as text rather than convert to dates, use Format > Number > Plain text before entering or pasting them.

A date may be stored as a number even when the cell displays a calendar date. Changing its number format can therefore reveal a serial number, such as 45292, instead of the date. Use the steps below to choose the display that fits your goal and to avoid changing other formatting or data by accident.

What You’ll Need

Access to the Google Sheets file in a web browser, with permission to edit it.
The cell, column, or range that currently displays dates. If you are unsure which cells are affected, check the column and a few rows before applying a change to the whole range.
A decision about the desired result: a numeric serial value, plain text, or a different date display. These are different outcomes, so choose the one that matches what you need to do next.

Step-by-Step

Open the spreadsheet and find the affected cells. Open the file in Google Sheets in your browser. Look for values that appear as dates even though you want to see something else, such as a number or text. Click one affected cell and check the formula bar above the grid. The formula bar can help you distinguish the cell’s stored content from its formatted display, though the visible date may still represent a numeric date value.
Select the cells whose date display you want to remove. Click a single cell to change just that cell. To select a contiguous range, click the first cell and drag across the range, or click the first cell and then Shift-click the last one. To select an entire column, click its letter at the top of the grid. Use a limited range when possible: selecting a whole column can also change formats on blank cells and unrelated entries in that column.
Open the number-format menu. In the menu bar, choose Format > Number. A list of number formats appears, including options such as Automatic, Number, Date, and Plain text. This is the relevant menu for changing a date’s display. Do not use the browser’s own formatting controls or a menu in another spreadsheet program; the instructions here are for Google Sheets in a web browser.
Choose Number to display the stored date value as a number. Click Number in the Format > Number menu. A cell that contained a date value should now show its serial number, possibly with decimal places if the value also includes a time. For example, a date displayed as a calendar day may appear as a number in the 45,000 range. The number is not an error; it is the stored value displayed without the date presentation.
Check whether the result is what you intended. Review the changed cells, including a few at the beginning and end of the selection. If your aim was to show the underlying numeric value, you are done. If you expected to see the original characters you typed, such as 03/04/2025, Number may not be the right choice: that date could have been converted to a numeric date value when it was entered. See the troubleshooting section for options when you need text instead.
Use Plain text when you want text rather than a date value. Select the relevant cells and choose Format > Number > Plain text. This is especially useful before typing or pasting entries that Sheets might interpret as dates, such as 3/4 or a value beginning with a zero. For cells that already contain date values, changing the format to Plain text does not reliably reconstruct the exact original text that was entered; it changes the display treatment of the stored content.
Preserve other formatting if you only need to remove the date display. Changing the number format through Format > Number usually leaves styling such as fill color, font, and borders alone. Avoid using Format > Clear formatting just to change a date: that command removes other formatting too. If the cells also have colors, borders, or text styling that you want to keep, Number is the more targeted choice.
Verify sorting, formulas, and nearby data. If the cells are used in formulas or a date-based sort, make sure the new display still suits the task. A date changed to a number remains numeric and can still be used in calculations, but it may no longer be obvious to someone reading the sheet that the number represents a date. If the column needs to function as dates, keep a date format and instead adjust the particular display using the date-format options.

To apply a different date appearance rather than remove the date display entirely, select the cells and open Format > Number > Custom date and time. Choose or assemble a format there, then apply it. This changes how dates look while retaining their role as date values.

Common Mistakes

Expecting the original typed characters to return. Once Sheets has interpreted an entry as a date, it generally stores a date value rather than a record of the exact characters originally typed. Changing the format can reveal a number, but it cannot necessarily restore the original separators, leading zeros, or date order.
Choosing Automatic and assuming it always means “not a date.” Automatic is a general number-format option, not a guarantee that a date-like value will display as ordinary text. If your goal is to see the serial value, choose Number. If the goal is to keep new entries as characters, set the cells to Plain text before entering them.
Changing an entire column when only a few cells need attention. A column can contain dates, numbers, headings, and notes. Applying a format to all of it may make correct values look wrong. Select the smallest range that contains the affected cells, and check the selection highlight before applying the menu command.
Using Clear formatting for a number-format problem. Clearing formatting can remove font choices, colors, borders, and other visual styles along with the date format. Prefer Format > Number > Number or Plain text, depending on the intended result.
Confusing the date’s display with its stored value. A cell that looks like a date may contain a numeric value. Formatting does not usually erase that value, but replacing the cell contents by typing over them does. If the data matters, make a copy of the sheet or duplicate the affected column before trying a broad change.

Tips

Choose the format based on what you will do with the cells. Keep dates as date values if you need chronological sorting, date calculations, or date-based formulas. Use Number when you specifically want to inspect or display the underlying serial. Use Plain text for identifiers or entries whose characters must stay as entered, rather than values intended for date arithmetic.
Set Plain text before pasting potentially ambiguous entries. If a list contains values such as 1-2, 03/04, or codes with leading zeros, select the destination range first and apply Format > Number > Plain text. Then paste the data. Check a few entries afterward, because copying cells from another source can bring their formatting along too.
Use a test cell when the data is important. Copy one affected cell into an empty area or duplicate the tab, then try Number or Plain text there. Compare the result with the original before changing a large range. This is a quick way to confirm whether you want a serial number or text.
Keep date values readable when the purpose is only cosmetic. If a date is correct but appears in an unwanted layout, use Format > Number > Custom date and time and select a suitable pattern instead of converting it to Number. This preserves date-based behavior while changing the appearance.
Remember that menus can vary slightly by interface language or updates. The commands described are Google Sheets menu paths in a web browser. Excel has its own number-format menus and keyboard shortcuts; do not assume that an Excel instruction or shortcut will behave identically in Sheets.

Troubleshooting

The cells show numbers, but I wanted words or the original date text. Number displays a numeric date serial, not the original characters. If you need a text label, type or paste the desired text into cells formatted as Plain text. If you do not know the exact original entry, check the source data, a backup, version history, or another copy; the format change alone cannot infer whether an ambiguous date was intended as month/day or day/month.

The date format returns after I edit a cell. Check whether the cell is part of a range with an applied format, whether you pasted content with formatting, or whether another editor changed the format. Re-select the affected range and apply Number again. When pasting, use the paste option that avoids carrying source formatting if it is available in your interface, or paste into a preformatted Plain text range when the content must remain text.

Only some cells change. Confirm that the selection includes every affected cell and that there are no merged cells or separate ranges outside the highlighted area. If the sheet has a filter, hidden rows, or protected cells, check the affected rows and your editing permissions. Repeat the format change on the remaining cells that you can edit.

Dates display differently from one another after the change. The selected cells may not all contain the same kind of value. Some may be true date values, others may be text that resembles dates, and some may include times. Number reveals numeric values; text entries may remain text. Inspect individual cells and, if needed, standardize the data source before applying one format to the full range.

I changed the wrong cells. Use the Undo command immediately, or press Ctrl+Z on Windows/ChromeOS. On Mac, use Command+Z. Undo is appropriate for a recent formatting change; if other edits have happened since, review them before undoing. For an important sheet, use version history or a copy to recover from larger changes.

Frequently Asked Questions

Does removing a date format delete the date?
No. Applying Number changes the display, and the date value remains in the cell as a number. The value can still be used numerically, though it may be less recognizable as a date.

How do I stop Google Sheets from changing what I type into a date?
Before entering or pasting the values, select the destination cells and choose Format > Number > Plain text. For a one-off entry, you can also type an apostrophe before the value; Sheets treats the entry as text, and the apostrophe is not displayed as part of the cell value.

Can I remove date formatting from just one cell?
Yes. Select that cell, then choose Format > Number > Number. Only the selected cell’s number format changes. Check that it is not part of a larger selection before applying the command.

Why does a date become a large number?
Google Sheets stores date values as numbers that count days from a starting date, with any time represented as a fraction of a day. When you choose Number, Sheets shows that stored numeric value instead of rendering it as a calendar date.

Can I change the appearance without losing date calculations?
Yes. Use Format > Number > Custom date and time and choose another date pattern. The cell remains a date value, so date sorting and calculations can continue to work.

Is the process the same in Excel?
The idea is similar, but the menus differ. This guide uses Google Sheets in a web browser; in Excel, use Excel’s own number-format controls rather than following the Google Sheets menu path.

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.