Recent

SharePoint remove commas from number fields

In some instances you don’t want number fields to display with comma’s in SharePoint views. Unfortunately there is no setting to not display comma’s on number fields.
SharePoint-remove-commas-16-1

Use Calculated field to remove comma’s from number field

For this example I’m going to display a number column (Alias) in a calculated field (Alias Calculated).
Create a calculated field, and for the

SharePoint-remove-commas-16-2

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

2. Type in the following formula:
=text(

Then double click on your number field in the Insert Column box

then type:
,”0″)

Your formula should display something like this: =text([Alias],”0″)
SharePoint-remove-commas-16-3

Choose a number field, with 0 decimal places and click OK.

SharePoint-remove-commas-16-4

This should display your number column without the commas while retaining the benefits of using a number field (field validation & sorting):
SharePoint-remove-commas-16-5

*If you save the number as in the Text format type, sorting will not work correctly.

About Nick Hurst (84 Articles)
SharePoint and Nintex developer who strives to find easy to deploy and maintain solutions for business problems.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: