Google Sheets does not allow you add in a number with a leading ‘+’ sign. As a workaround you can use the CONCATENATE function to combine the ‘+’ sign with any number.
- Enter ‘+ into cell A1
Note: Be sure to include the leading apostrophe otherwise you will receive an error
- Enter the phone number into cell B1
- Enter =CONCATENATE(A1:B1) into cell C1
- Copy cell C1
- Paste special > Values only into cell C1 (this will paste the phone number rather than the formula into the cell)
- Copy the phone numbers to the users or contacts spreadsheet and import
The numbers will now appear with a ‘+’ sign in BetterCloud!