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 "http://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

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!

2 thoughts on “SharePoint Number Column without Commas

  • July 10, 2020 at 3:55 PM

    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
  • August 14, 2018 at 3:34 PM

    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