How to remove thousand separator in SharePoint Online

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.

remove thousand separator sharepoint
remove thousand separator sharepoint

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.

sharepoint number format no comma
sharepoint number format no comma

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.

How to remove commas from number columns in SharePoint List
How to remove commas from number columns in SharePoint List

Step-2: Then in the Edit column, click More options to expand and see more options.

sharepoint online format number without comma
sharepoint online format number without comma

Step-3: Here, you can see the Use thousands separator option. Disable this option like below:

sharepoint column formatting number without comma
sharepoint column formatting number without comma

Step-4: Now, you can see, the comma has been removed from the number field values like below:

sharepoint list number format without comma
sharepoint list number format without comma

This is how to remove a thousand separators in SharePoint or how to remove commas from number columns in SharePoint List.

See also  [Solved] windows server appfabric download error SharePoint 2016/2013

Related SharePoint tutorials:

>