In Google Sheets how do I enter the plus sign at the start of a field value?

Viewed 1059

I'm creating a spreadsheet where one column must hold phone numbers. Some phone numbers have the plus sign at the beginning of the string.

However, Attempting to enter a '+' at the start of a field activates a feature of Google Sheets.

How do I turn this feature off and get fields to just accept alphanumeric strings?

2 Answers

You should use an "escape" character: '

This way:

    '+1234

you can add it as text string like:

="+99 555 653"
Related