How to Stop Google Sheets from Automatically Formatting Text as Dates (Step-by-Step)

Last Tuesday, my friend Sarah—who runs a small handmade candle shop—called me in absolute tears. She was trying to upload her new seasonal inventory catalog into Google Sheets. Every single time she typed her batch code 10-12 (meaning Batch 10, Item 12), Google Sheets aggressively transformed it into Oct-12.

If you have spent more than five minutes working inside a spreadsheet, you know that exact feeling of mild rage. You type a simple product ID, a score, or a ratio, and the software decides it knows what you meant better than you do.

Google Sheets is a fantastic tool, but its obsession with automatically guessing dates can easily derail your workday. The good news? You do not have to keep fighting the algorithm. I have spent years building custom tracking systems for small businesses, and today I am going to show you the exact tricks I use to force Google Sheets to leave your text alone.

Why Google Sheets Loves Turning Everything Into Dates

Before we fix it, it helps to know why this keeps happening. Google Sheets uses an automatic data detection engine. Whenever you type something containing hyphens (-), slashes (/), or numbers separated by dots, the app immediately asks itself: Could this possibly be a date?

If the answer is even remotely yes, it reformats the cell instantly. The real problem is that Google Sheets does not just change the visual appearance. It converts your text string into an underlying date serial number. That means pressing backspace or changing the font does not always restore your original data layout.

3 Quick Fixes to Stop Auto-Date Formatting Instantly

Depending on whether you are typing a single code or setting up a massive table, here are three distinct ways to protect your text.

Method 1: The Trusty Apostrophe Trick (Fastest for Single Cells)

If you just need to drop a quick code like 01-05 into a cell without Google Sheets messing it up, this single keystroke works like magic.

1. Click on the target cell.
2. Type a single apostrophe (') at the very beginning of your entry.
3. Type your string right after it (for example: '12-24).
4. Hit Enter.

Pro Tip: Do not worry about the apostrophe sticking around. It stays completely hidden in the main view and will not show up when you print or export your document. It simply acts as a hidden directive telling Google Sheets: "Treat everything after this strictly as plain text."

Method 2: Pre-Format Cells as Plain Text (Best for Columns & Tables)

Adding an apostrophe to dozens of rows gets old very fast. If you are building an inventory list, product catalog, or grade book where an entire column will contain hyphens or slashes, pre-formatting is your best move.

1. Highlight the specific cells, columns, or rows you want to edit.
2. Click on Format in the top navigation bar.
3. Hover over Number in the drop-down menu.
4. Select Plain text from the top of the list.

Now, anything you type into those pre-formatted cells will stay exactly as you wrote it. Google Sheets turns off date auto-parsing for that selected range.

Method 3: Lock Text in Formulas using TEXT()

If you are writing a formula that merges text and numbers—like joining a department code in cell A2 and an item number in cell B2—Google Sheets might turn the output into an unwanted date serial number.

To lock your output as text, wrap your cell references inside the TEXT function like this:

=TEXT(A2, "@") & "-" & B2

The @ symbol tells Google Sheets to treat the value purely as text, preventing any surprise date conversions in your formula outputs.

How to Import CSV Files Without Destroying Your Data

Importing files from external systems like Shopify, Etsy, or your bank is usually where auto-formatting causes the biggest mess. You import a 500-row CSV file, and suddenly half your SKU numbers look like calendar days.

Here is how to stop Google Sheets from altering your data during the import process:

1. Open your spreadsheet and go to File > Import.
2. Upload your CSV or text file.
3. In the import settings pop-up window, locate the option labeled Convert text to numbers, dates, and formulas.
4. Uncheck that box.
5. Click Import data.

By unchecking that single toggle, you instruct Google Sheets to read every piece of incoming data as raw, plain text. Your product codes, fractions, and account numbers will stay completely intact.

How to Fix Data That Google Sheets Already Ruined

What if you are reading this article after Google Sheets already wrecked your sheet? Do not worry, you do not have to start from scratch.

If your codes turned into dates like Nov-24 and you need them back in the 11-24 format, try this formula recovery trick:

1. Insert a new, empty column next to your corrupted data.
2. Use the TEXT function to extract the original numbers back out.
3. If cell A2 shows Nov-24, enter =TEXT(A2, "mm-yy") in cell B2.
4. Drag the formula down the rest of your column.
5. Copy the new column, right-click, and choose Paste special > Values only.

Frequently Asked Questions

Can I turn off auto-date formatting permanently for all new sheets?

Unfortunately, no. Google Sheets does not currently offer a global account setting to turn off automatic date detection across all future documents. You need to apply plain text formatting or uncheck the import box for each individual sheet.

Why did my cell turn into a random 5-digit number when I selected Plain Text?

If you change a cell to "Plain text" after Google Sheets has already converted it to a date, it displays the underlying date serial number (like 45210). You need to change the format to Plain Text before entering the data, or re-type the text after changing the format.

Will the single apostrophe trick break my calculations?

Yes, if you plan to do math with those numbers. Google Sheets treats apostrophe-prefixed entries strictly as text strings. If you try to sum or multiply those cells, your formula will likely ignore them or return zero.

Wrapping Up

Spreadsheets are supposed to make our lives easier, not give us headaches over unwanted date conversions. The next time Google Sheets tries to turn your product codes or ratios into a calendar date, just drop in an apostrophe or set your columns to Plain Text ahead of time.

Have you run into any other weird spreadsheet glitches that made you want to pull your hair out? Leave a comment below or send me a message—I am always happy to help you figure out a fix!