How to enter international phone number in Google Sheets

Problem

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.

Solution

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