Formatting of Standard Phone Field Data type
|Knowledge Article Number||000181563|
|Description||User wants to know about the formatting of Phone Field Data type.
1. If telephone number contains 9 digits -
It will be Saved as it is in Salesforce - Ex: 949243871
2. If telephone number contains 10 digit -
If the phone number starts with 1 it will be saved as is without any formatting.
If starts with any other digit other than 1, it will be Saved as : (***) ***-****
3. If telephone number contains 11 digits there are 2 cases
· If 11 digit number starts with 1 it will automatically convert in the 10 digit format by removing the 1 in the number
Ex: If the number is like this => 12365478963
It will be saved as in Salesforce => (236) 547-8963
Note: It removes the 1 and formats the other numbers as like 10 Digit Number.
· If 11 digits but not starting with the 1 then it will stored as it is in the Salesforce.
Ex: If the number is like this => 23654789631
It will be saved as in Salesforce => 23654789631
If you do not want this formatting for a ten- or eleven-digit number, enter a “+” before the number, for example, +49 1234 56 78-0.
Note: A phone field can accept a maximum of 40 digits to be entered in the field. Also note that this can only be done via User Interface and NOT via the API.
For more details please see - Guidelines for Entering Currency, Dates, Times, and Phone Numbers
This does not apply to Phone numbers of records created from ,example Web-to-Lead.
This is described in this link from IdeaExchange: