Problem with plus symbol automatically removed when inserted into Google Sheet cell

Hi everyone.
Does anyone know why the “+” sign is not saved in Google Sheet, even though it does appear in the output of the MAKE bubble and in the input of the Google Sheet bubble itself? Thanks
signo mas
signo_2

Its most likey cause that column is formatted for numbers. You need the format to be text string.

To save the numeric value beginning with a + symbol, you have to add a single quote character ' before it:

'+1234567890

This is not a Make issue, as it is standard Excel and Google Sheets behaviour.

Example:

Hope this helps! Let me know if there are any further questions or issues.

@samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

3 Likes

thank you very much!!!

1 Like