How to enter international phone number in Google Sheets


I was trying to enter an international phone number of the format +65-12345678 into a cell in Google Sheets and it would turn into ERROR. I changed the formatting of the cell using Format → Number → Plain text. But this error still persisted.


Because the + sign is treated specially when it appears as first character, there is no standard formatting that will work. We need to create a custom formatting to enter this phone number.

Click the cell where you want to enter phone number and choose Format → Number → More formats → Custom Number Format. Enter this format: +##-########. This tells Google Sheet that we will enter 10 digits, represented by the hash characters and it should show up as shown in the format.

Now paste 6512345678 into the cell and it will be displayed as +65-12345678

2 thoughts on “How to enter international phone number in Google Sheets

  1. Hi Ashwin,

    Do you have any idea how I can accomplish this: I regularly have to copy a phone number in this format into a Google spreadsheet:
    (123) 123-1234

    But I want it to display as: +1 (123) 123-1234

    Thanks for your help!



  2. Thanks for the suggestion. This only works if every single number has 10 digits. A better method would be to replace “+” with “00”. That should work as well…


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.