In this SharePoint tutorial, we will discuss, how to remove thousand separator in SharePoint Online. In a very easy way, we will see, how to remove commas from number columns in SharePoint List.
When you will create a number column in a SharePoint list, by default, you will see, the values will come with thousand separator (with comma).
Here is a list, you can see, as an example.
Look at the Value column in the SharePoint list that has values with commas. Just to let you know that the Value column is a Number column.
Like the 20000 is coming as 20,000.
There will be scenarios where you might not need the comma or the thousand separator, instead, it should come as a whole number.
Here is the column I have created like this.
How to remove commas from number columns in SharePoint List
In classic SharePoint, you can use some JSOM to do the column formatting for no comma. You can check the article here.
If you are using the modern SharePoint list, then it is easier to remove commas from number columns in SharePoint List.
You can use the same steps while creating a new column or modifying an existing column.
Step-1: Open the SharePoint Online list, click on the Column (arrow) -> Column settings -> Edit.
Step-2: Then in the Edit column, click More options to expand and see more options.
Step-3: Here, you can see the Use thousands separator option. Disable this option like below:
Step-4: Now, you can see, the comma has been removed from the number field values like below:
This is how to remove a thousand separators in SharePoint or how to remove commas from number columns in SharePoint List.
Related SharePoint tutorials:
- Power Automate Copy Folders + 10 Examples
- SharePoint list title column
- Create a canvas app in PowerApps from a SharePoint list
- SharePoint list view threshold
- Customize SharePoint List Forms with PowerApps
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com