SharePoint Online List Number Without Comma

In this SharePoint Online tutorial, we will discuss, how to remove commas from a number column in the SharePoint Online list.

Also, we will see what are the different ways to remove a thousand separators from the SharePoint list Number column.

Recently, while I was working with a SharePoint list number column, I have seen a comma separator that is appearing as 27,35,62,720. But as per my requirement, the number column should not display with a comma and it should look like 273562720.

In this post, we will see how to achieve this need.

Also, Read: SharePoint Online Team Site Vs Microsoft Teams

SharePoint List Display Number Without Comma

There are two different ways to remove commas from a SharePoint Number column. Such as:

1. Using Edit option
2. Using Format this column option

SharePoint List Display Number Without Comma using Edit option

Now we will see how to remove a thousand separators from the SharePoint list Number column.

Example:

• I have a SharePoint Online list named Floormats. This list has a Number column called Floormat Quantity Available.
• In the below screenshot, you can see the number column (Floormat Quantity Available) appearing with a separator like 65,952. But I do not want to display this number column with a separator comma and it should display like 65952 in my case. So I will remove the separator from the number column.

Refer to the steps below to remove a thousand separators from a SharePoint Number column:

• Expand the Number column (Floormat Quantity Available) -> click on the Column settings -> Click on Edit.

• On the Edit column pane, Expand More options -> Disable the ‘Use thousand separator’ (Before this option was enabled by default) -> Click on Save.

• Now, go back to your existing SharePoint List (Floormats) and you can see the number column (Floormat Quantity Available) has been updated without separator commas as shown below.

This is how we can work with SharePoint List Display Number Without Commas using the Edit option.

Check out: SharePoint Online list vs document library

SharePoint List Display Number Without Comma using Format this column option

Here, we will discuss how to work with SharePoint List Display Number Without Comma using Format this column option.

Similarly, I have taken the same SharePoint Online list named Floormats. This list has a Number column called Floormat Quantity Available. To remove commas from this SharePoint number column, follow the steps below:

• Expand the Number column (Floormat Quantity Available) -> click on the Column settings -> Click on Format this column.

• On the below Format view window, Click on Advanced mode as shown below.

• Again ‘Format view’ dialog box pops up > Here, inside the formula box, we need to provide the JSON code as below:

{

  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

  "elmType": "div",

  "attributes": {

    "class": "=if(@currentField > 0,'', '')"

  },

  "children": [

    {

      "elmType": "span",

      "style": {

        "display": "inline-block"

      }

    },

    {

      "elmType": "span",

      "txtContent": "@currentField"

    }

  ]

}

Refer to the screenshot below.

• Now, come back to the existing SharePoint Online list (Floormats) and we can see that the comma is removed from the number column (Floormat Quantity Available) as shown below.

This is how we can remove the comma from the Number column in SharePoint Online List.

Additionally, you may like some more SharePoint Online articles:

• How to Customize SharePoint Online Team Site
• Create, Update, and Delete SharePoint Online List Items
• SharePoint Online List Permissions
• SharePoint Online List Item level permissions
• SharePoint list conditional formatting based on a date

Conclusion

This SharePoint Online tutorial taught us about how to remove commas from a number column in the SharePoint Online list.

Also, we saw what are the different ways to remove a thousand separators from the SharePoint list Number column.