I am to store an 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
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?