Month: November 2025

If your or your users have created a column in SharePoint Online and chose its type as Number, then it will have commas as the thousands separator for numbers over 3 digits.  For fields such as EmployeeID or Invoice Number, you may not want the commas.  The solution is to Format the column, go to Advanced, and put in the following JSON code:

/* Add this to the JSON formatting section   */
/* This is for when a number field shows thousand separators */
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField > 0, '', '')"
  },
  "txtContent": "=toString(@currentField)"
}