General

Re: Prevent the Number field from auto-inserting commas

Roberto A. — Wed, 22 Jan 2020 19:01:05 GMT

These steps worked perfect - thank you!

Re: Prevent the Number field from auto-inserting commas

mypinstripes — Fri, 24 Oct 2014 14:57:17 GMT

Just came across this thread. This is the first InfoPath form I am creating where there is a SharePoint list column that has more than three digits. So I ran in the comma problem for a year. 2014 - 2,014. The data type in InfoPath is greyed out. I assume this is because the form is tied to a SharePoint list where the column is just defiined as a number. I created a new field in the form and when I looked under data type there was no whole number listed. This is InfoPath and SharePoint 2010 by the way.

Microsoft certainly does some odd things with both products (I have a long list of issues that I have found), but there is absolutely no way to get rid of the comma without making it a text field/converting the value to text? I was hoping in the year-plus that this post was written that someone came up with a better solution.

Thanks,

Drew

Re: Prevent the Number field from auto-inserting commas

Hilary Stoupa — Mon, 11 Feb 2013 18:12:24 GMT

You'll also find the format button available for decimals, dates, datetime, and time datatypes.

Re: Prevent the Number field from auto-inserting commas

AlexK — Mon, 11 Feb 2013 17:51:30 GMT

I was able to figure out how to do it, even though there seems to be no documentation on this feature throughout the world wide internets. Anyway, here are the steps:

1. Right-click the number box (not from the Fields section, but on the form itself) and select "Text Box Properties"

2. Under the Data tab, find "Data Type" and set it to "Whole Number (integer)"

3. To the right of that, click the "Format..." button: This is the key part!

4. Now you can see at the bottom an option for "use a digit grouping symbol". Right there is how to remove the auto-commas, but initially it is grayed out.

5. Under Format, select the "Number" radio button option. The check box for the grouping symbol is now enabled. Un-check this, click OK.

6. ???

7. Profit!

Re: Prevent the Number field from auto-inserting commas

AlexK — Mon, 11 Feb 2013 17:35:17 GMT

My data type is set to Whole Number already and I do not want the display to show commas. I'm not really worried about how it is represented underneath, I just don't want to see the commas on the form.

Re: Prevent the Number field from auto-inserting commas

Patrick Halstead — Sun, 10 Feb 2013 01:17:33 GMT

Hi AlexK,

The data representation of the number field will not contain commas. That's just formatting for display. Please make sure the data type is Whole Number or Decimal. Those will support comma formatting, but the data format will be what you expect. To verify, you can save your form as XML, open in Notepad (or similar) and search for the field name.

Best of luck!

Prevent the Number field from auto-inserting commas

AlexK — Fri, 08 Feb 2013 19:47:01 GMT

For an InfoPath browser form submitting to a SharePoint 2010 form library, how can I stop the auto-formatting of a Number field from inserting commas into numbers >= 1000? For example, if a field was for an ID or a credit card number, commas would not be appropriate.