SharePoint Online: Number Column without Comma

Requirement: Display number column without a comma in SharePoint Online list.

How to remove the comma from the number column in SharePoint Online?

Comma separators don’t make sense on certain number column values like “Year”! So, we wanted to display a number without comma in a SharePoint Online list. While the methods discussed on my another article How to display number without comma in SharePoint? Applies to SharePoint Online as well, This article uses JSON technique to format number column without comma symbol.

sharepoint online number column without comma

Here is how to format number column without comma in SharePoint Online:

  • Navigate to your list, Select the little drop-down in the target column, Choose “Column Settings” >> Select “Format this column”.sharepoint online remove comma from number column
  • Paste the below JSON, Save and Close.
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField > 0,'', '')"
  },
  "children": [
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

And the result of SharePoint Online list number without comma:

sharepoint online format number column without comma

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

Leave a Reply