Answer the question
In order to leave comments, you need to log in
How to disable autocorrect number for date in Google Docs?
In one column, data like 1.03 is converted to March 3rd. There is no strength.
The data is taken from another place in a large volume, it is not possible to change the dot to a comma.
The column needs to be calculated, so the text format is not suitable, a numeric one is needed.
Answer the question
In order to leave comments, you need to log in
The simplest way to tell the spreadsheet editor not to autocorrect data is to use the apostrophe character ('). It must be placed before the input data.
After entering numerical data with an apostrophe in front, autocorrect for a number will not be performed (and the apostrophe itself will disappear). However, this also applies to any other data and autocorrect in almost all modern spreadsheet editors.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question