{"id":3999,"date":"2019-01-21T14:27:10","date_gmt":"2019-01-21T09:27:10","guid":{"rendered":"https:\/\/aasims.wordpress.com\/?p=3999"},"modified":"2025-04-09T10:22:16","modified_gmt":"2025-04-09T10:22:16","slug":"sharepoint-remove-commas-from-number-fields","status":"publish","type":"post","link":"https:\/\/aasimnaseem.com\/blog\/sharepoint-remove-commas-from-number-fields\/","title":{"rendered":"SharePoint remove commas from number fields"},"content":{"rendered":"

In some instances you don\u2019t want number fields to display with comma\u2019s in SharePoint views. Unfortunately, there is no setting to not display commas on number fields.
\n\"SharePoint-remove-commas-16-1\"<\/p>\n

Use Calculated field to remove comma\u2019s from number field<\/h3>\n

For this example, I\u2019m going to display a number column (Alias) in a calculated field (Alias Calculated).
\nCreate a calculated field, and for the<\/p>\n

\"SharePoint-remove-commas-16-2\"<\/p>\n

**Do not copy and try to paste this formula, type it in your calculated field and make sure to use the Insert Column option.<\/p>\n

2. Type in the following formula:
\n=text(<\/strong><\/p>\n

Then double click on your number field in the Insert Column box<\/strong><\/p>\n

then type: ,\u201d0\u2033)<\/strong><\/p>\n

Your formula should display something like this: =text([Alias],\u201d0\u2033)
\n\"SharePoint-remove-commas-16-3\"<\/p>\n

Choose a number field<\/strong>, with 0<\/strong> decimal places and click OK<\/strong>.<\/p>\n

\"SharePoint-remove-commas-16-4\"<\/p>\n

This should display your number column without the commas while retaining the benefits of using a number field (field validation & sorting):
\n\"SharePoint-remove-commas-16-5\"<\/p>\n

*If you save the number as in the Text format type, sorting will not work correctly.<\/p>\n","protected":false},"excerpt":{"rendered":"

In some instances you don\u2019t want number fields to display with comma\u2019s in SharePoint views. Unfortunately, there is no setting to not display commas on number fields. Use Calculated field to remove comma\u2019s from number field For this example, I\u2019m going to display a number column (Alias) in a calculated…<\/p>\n","protected":false},"author":1,"featured_media":4532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"quote","meta":{"footnotes":""},"categories":[12],"tags":[805,1155,926],"class_list":["post-3999","post","type-post","status-publish","format-quote","has-post-thumbnail","hentry","category-random","tag-nintex","tag-programming","tag-sharepoint","post_format-post-format-quote"],"_links":{"self":[{"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/posts\/3999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/comments?post=3999"}],"version-history":[{"count":3,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/posts\/3999\/revisions"}],"predecessor-version":[{"id":4533,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/posts\/3999\/revisions\/4533"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/media\/4532"}],"wp:attachment":[{"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/media?parent=3999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/categories?post=3999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aasimnaseem.com\/blog\/wp-json\/wp\/v2\/tags?post=3999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}