11/14/2017

How to type your contact number in the Google Sheet

Save the phone in Google Sheet
You want to save the contact details in the Google Sheet for future reference of your family members are your business people numbers for your business related processes. But the most of the people facing some default in the save the number contact number in the Google Sheet.

Also Read: Google Drive Plug-ins for For Microsoft Office edit and save the file directly to Drive

In the mobile are landline number we used some special character like plus [+], minus [-]. The Google Sheet cell will confuse on the special character, whether it will be an Arithmetic value.

Buy solving this issue you can enter the mobile in the cell like this way

First Option:

=”+1-2443-6457-9000”

First, start with = and enter “ and end number with “


Second Option:

‘+1-2443-6457-9000

Just start with a single quote ‘ and followed by your number.

Share this: