SharePoint Online: Number Column without Comma

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

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

By default, SharePoint will display numbers with a comma as a thousand separator, but it is possible to modify this behavior and display numbers without a comma. In this tutorial, we will show you how to display numbers without a comma 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:

Option 1: Disable the “Use thousands separator” option

The Modern view in the SharePoint Online list has the “Use thousands separator” property.

  • Create or edit a Number Column in Modern View and >> In the column properties, Click on “More Options” and set the “Use thousands separator” to “No”.number column without comma - thousands separator in sharepoint online

Please note, this option is available only in the Modern view and not under list settings >> Field settings.

Option 2: Format the Number column to Remove the Comma

To display numbers without commas in SharePoint Online, you can use the format column option in the Column settings for a list or library.

  • 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

Conclusion

In conclusion, it is straightforward to modify the way numbers are displayed in SharePoint Online. By following the steps outlined in this tutorial, you can easily change the default display of numbers with a comma as a thousand separator to display numbers without a comma. This can be useful if you are working with large numbers or if you prefer a different formatting style for your data. Whether you are a power user or new to SharePoint, this tutorial will help you customize the way numbers are displayed in your lists and libraries.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

5 thoughts on “SharePoint Online: Number Column without Comma

  • Well I have tried everything and it doesn’t work, all I have to say is that its typical of Microsoft to have a cra* system like this you cant even change. The old on-premises Sharepoint was fine so way change it to this rubbish? Defies belief.

    Reply
  • I was having the same issue and I found a solution.
    Use CONCATENATE in the formula: =CONCATENATE(YEAR([your date field]))

    The commas are gone in both column view and grouped view.

    Reply
  • I had a date column then I had another column called year and used the formula “=TEXT(Date,”yyyy”)” to convert it to a year but there was a seperator.

    Using the JSON worked.
    Thanks for the help!

    Reply
  • When I copy data from grid view to Excel, the thousand separators appear in Excel files

    Reply
  • 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

Your email address will not be published. Required fields are marked *