Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

How to enter international phone number in Google Sheets

📅 2018-Jan-11 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ google sheets, phone number ⬩ 📚 Archive


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

© 2022 Ashwin Nanjappa • All writing under CC BY-SA license • 🐘📧