I tried putting the "+" symbol in front of the telephone number in Excel but it is not working?

I tried putting the "+" symbol in front of the telephone number in Excel but it is not working?

Excel sees these as numbers so when you put a + one of two things will happen:

  1. It will either drop the + 
  2. It will try and add it up (Microsoft Excel found an error in your formula error box appears)

Click the top of the column whilst holding down Ctrl – this will select all the cells in the column. Right click and select Column Formating. Select the option Text and click ok.

    • Related Articles

    • How do I add a + to a series of phone numbers on excel prior to import?

      Download Kutools (http://www.extendoffice.com/product/kutools-for-excel.html) – free for either 14 or days, then $ 19 for two years. After install you have an additional menu item in Excel called Kutools. Select the Column you want to add +, Go to ...

    • Zoho CRM Telephony - which telephone companies integrate with Zoho CRM

      The answer is more complex than a standard list. There are a number of companies on the list, but not all operate or provide service in your country or region. Next with Zoho CRM Telephony, not all companies offer the same services and / or integrate ...

    • I have tried importing and it fails, says missing header rows

      When importing data into Zoho CRM the first row needs to have a header row. The header row is the field name that you are importing to. Note the header name doesn't need to match the field name, so long as you understand the relationship you can map ...

    • How to add Auto Number Fields to Zoho CRM

      You go to Setup - Fields - Create a Custom Field then select the Field Type as Auto Number. You have options for a prefix, suffix and what you would like the starting number to be. You can also apply the auto number retrospectively by selecting the ...

    • What is Case ID and how does it relate to Case Number on Cases?

      During the initial days of CRM, this is how Zoho implemented. Technically, Zoho did generate 2 running id's during run time, one will be the Record id and the other as Case id. Zoho purposefully made a difference as 1 or 2 (2 in your case) to make ...