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
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.
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