How to enter international phone number in Google Sheets

Updated post here: https://codeyarns.github.io/tech/2018-01-11-how-to-enter-international-phone-number-in-google-sheets.html

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!

    John

    Like

  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…

    Like

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.