How to Stop Google Sheets from Changing numbers to dates

In this tutorial, you will learn How to Stop Google Sheets from Changing numbers to dates.

Stop Google Sheets from Changing numbers to dates

To stop Google Sheets from Changing numbers to dates, Select the cell with the number, click on the Format menu->Numbers and Choose Plain text. Another method is to use an apostrophe (‘) before the number

How to Stop Google Sheets from Changing numbers to dates: Step by Step Guide

Whenever you type a number /string Google sheets will interpret it as a date and converts it into a date format automatically.

For instance, if you type a number say 06-2022 it will be automatically converted to a date format 1/6.

Enclosed are the steps to Stop Google Sheets from Changing numbers to dates

Step 1: Choose the cells in Google Sheet with numbers that you want to stop from auto conversion.

Step 2: Now Click on the Format->Numbers

  • Click on the Format menu on the Main menu bar
  • From the drop-down Select Number
  • Under Number Select Plain Text
Stop Google Sheets from Changing numbers to dates

Method 2: Using apostrophe (‘) before the number

You can also use an apostrophe (‘) before the number to stop google sheets from automatically converting the number to date.

For example type apostrophe (‘) before the number like this ’6-2022 or 6/2022.

How To Change Date Format - MS Excel
How To Change Date Format - MS Excel

Once you press enter you will get the desired number format and the apostrophe won’t be shown in the cell keep the original formatting intact.

How to Stop Google Sheets from Changing numbers to dates(Summary)

We hope this tutorial on How to Stop Google Sheets from Changing numbers to dates was useful.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )