SharePoint Remove Commas From Number Fields

via 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.

Tags:

5 Replies to “SharePoint Remove Commas From Number Fields”

  1. Howdy! I could have sworn I’ve been to this blog before but after browsing through some of the posts I
    realized it’s new to me. Regardless, I’m definitely
    delighted I discovered it and I’ll be bookmarking it and checking back regularly!

  2. Hello just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Ie.
    I’m not sure if this is a format issue or something to do
    with web browser compatibility but I thought I’d post to let you know.
    The design and style look great though! Hope you get the problem resolved soon. Kudos

    My web page: Spark Aura Skin Serum

  3. Undeniably believe that that you stated. Your favorite justification appeared to be at the web the simplest factor to
    be aware of. I say to you, I certainly get irked while folks
    consider concerns that they just do not understand about. You managed to hit the nail upon the top
    and outlined out the entire thing with no need side effect , people can take
    a signal. Will probably be back to get more. Thank you

    Here is my blog post; Rapid Keto Cut Review

Leave a Reply

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