SharePoint Calculated Column Remove Comma from Number

Here is a complete “SharePoint Calculated Column Remove Comma from Number” example. I will show you how to remove commas from a number column in the SharePoint list using a calculated column.

I have a SharePoint list named ‘User Details,’ which has a number column ‘User contact Number’ having comma-separated values. Based on that column, I will create a calculated column that displays numbers without commas.

SharePoint Calculated Column Remove Comma from Number

In this section, I will explain, step-by-step, how to remove commas from a number using SharePoint calculated column.

Follow the below instructions to achieve it:

• Open a SharePoint Online list, Click on +Add column -> Select See all column types and Click Next.

• Next, on Create Column window, Provide a name in the Column name box.
• Choose the data type as Calculated (Calculation based on other colums).

• Then, I applied the formula below to remove commas in the SharePoint calculated column in the Formula box.

=TEXT([User Contact Number],"0")

• After that, Choose the data type returned from this formula: Number(1, 1.0, 100) and choose Zero(0) in the Number of decimal places, and Click on OK.

• Then, a calculated column will appear in a SharePoint list displaying values without commas, as shown below:

This is all about removing a comma between numbers using the SharePoint calculated column.

Conclusion

Through this tutorial, I have explained how to remove a comma from numbers using a calculated column in sharePoint Online.

You may like to see:

• SharePoint Calculated Column If Statement
• SharePoint calculated column blank date
• SharePoint calculated column random number