Error with pasting phone number

  • Resolved a0137

    (@a0137)


    6 years, 5 months ago

    Hi there
    If I try to send phone number in this format +1 (888) 123-12-19 google sheet return *Formula paste error message* in cell
    How I can fix that?
    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)

  • 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?

    Plugin Author westerndeal

    (@westerndeal)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error with pasting phone number’ is closed to new replies.