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 specific number column values like “Year”! So, we wanted to display a number without a comma in a SharePoint Online list. While the methods discussed in my other article, How to show number without a comma in SharePoint? Applies to SharePoint Online as well. This article uses the JSON technique to format number columns without comma symbols.

sharepoint online number column without comma

Here is how to format the number column without a 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 a 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!

One thought on “SharePoint Online: Number Column without Comma

  • Hi. What happens, when you now group by Project Year? I had exactely the same problem and the JSON works fine for the column. In groups meanwhile there is still the comma shown. Can you maybe add a solution for that as well to your article?
    Thanks a lot and keep up the great work. I love your page!

    Reply

Leave a Reply