I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is
+420123456789
When I enter this phone it turns to just 420123456789
to be seen in the cell and =420123456789
to be seen in the formula/value bar. I would like to disable this conversion.
I've tried using Format → Numbers → Plain text applying it to the whole column as well as to the particular cell but it doesn't seem to work.
Any ideas how to overcome this?
Best Answer
If you prefix the data in the cell with a single quote—
'
—it should prevent any default formatting.