Format SharePoint Number Column without Commas

Problem: SharePoint Number columns shows, (comma) in View/Display Forms. There are specific numeric columns, User wanted to display without commas.

There is no direct way to remove comma/avoid thousand separators in SharePoint Number fields, But the below tricks help to get SharePoint 2007/2010/2013 number column values without commas.

Solutions:

Here are some solutions to show number fields without comma:

  1. Use “Single Line of Text” instead of “Number” column type, if possible. (But this will not stop users from entering alpha characters!)
  2. Use another calculated column with formula: = TEXT(Number_Column_Name, “0”). If you need sorting, you can use: =FIXED(Number_Column_Name,0,TRUE) 
  3. Add Integer field programmatically (As there is no interface to do this!)
    #Get all site collections of the provided web application 
    $Web = Get-SPWeb "https://projects.crescent.com/sites/Corp" 
    $ListName = "ProjectBudget" 
    $list = $web.lists[$ListName]  
    $list.Fields.Add("TotalValue", [Microsoft.SharePoint.SPFieldType]::Integer, $false) 
    
  4. If its for a view, You can use Dataview/XSLT web part with “format-number” formula as: <xsl:value-of select=’format-number(TotalValue,”#.00″) ‘/>
sharepoint format number column without comma

To remove thousands separator in SharePoint Online, use: Number Column without Comma in SharePoint Online

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!

2 thoughts on “Format SharePoint Number Column without Commas

  • I have tried to use both suggestions (1 and 2) and it didn´t work. It gets return an error… I don’t know what I am doing wrong….

    Reply
  • can you sugest me how iwill do chnage using 3 red approach XSLT.I am facing same issue in EDIT and view

    Reply

Leave a Reply

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