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.
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
Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book Microsoft Power Platform A Deep Dive. She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.