Do you want to remove comma from number field in Salesforce? In this Salesforce tutorial, I will explain how to remove comma from number field in Salesforce
Salesforce Remove Comma From Number Field
In the Salesforce number field, by default, there are commas between the digits to make them read easier. For example, when you create a field with a number as the data type, it always enters the number as 10,000 instead of 10000.
You can remove this comma from the number field by using the TEXT function. The syntax of the TEXT function is as given below:
TEXT(numberfield)Salesforce Number Field No Comma
Below are the steps to remove the comma from the number field in Salesforce.
1. Navigate to the Setup, click on the Object Manager, and search for the Object from whose number record you want to remove the comma. For example, Account object.
2. Click on Fields & Relationships from the leftbar and click on the New button.
3. Choose the Formula as the field type and click on the Next button.
4. Enter a Field Label for the formula, and the Field Name will be automatically populated. Here, I enter the Field Label as the Employee No Comma.
After that, choose Text as the Formula Return Type and click the Next button.
5. Enter the formula in the Advance Formula editor to remove the comma from the number field. Here is the formula:
TEXT(NumberOfEmployees)- In this formula, the Salesforce Text function was used to convert the passed number data type field NumberOfEmployees to text to remove the commas.
Click Check Syntax to make sure the formula is correct. Optionally, add the Description and Help Text. Then, click on Next.
6. Select the Profile to which you want to give the edit access of this field in Salesforce by checking the Visible checkbox. Then, click on the Next button.
7. Choose the Page Layout on which you want to include this field and click on the Save button.
To know how the number looks after removing the comma, open the Account object, choose any Record, move to the Details section, enter the Employee and you will get the Employee No Comma field as the number without comma.
Conclusion
I hope you have learned how to create formula to remove comma from the number in Salesforce.
You may like to read:
- Salesforce Formula to Calculate Days Between Dates
- Salesforce Formula Date to Text
- Convert DateTime to Date Salesforce
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.
