Error with pasting phone number

Having the exact same issue. I can’t control how people enter their phone number in the form I am using and therefore was wondering if maybe we could add a character at the beginning of the input before sending to Google Sheet (such as ‘ or “). Anyone has ever found a solution for this?

Hi @a0137, @dorianem

Thanks for using our plugin.

Here is what you can do:

Click the cell where you want to enter phone number and choose Format → Number → More formats → Custom Number Format. Enter this format: +1 (###) ###-##-## . 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 8881231219 into the cell and it will be displayed as +1 (888) 123-12-19

Hope this helps. Let us know further.