Number Site Column

A number column should contain only numerical data including percentages. SharePoint will not allow non-numeric data in this column. Number site columns are useful when the column is targeted to be used in calculations.

To configure a number site column, enter a name in the Column name textbox and complete the common properties. Then complete the additional column settings unique to this type of column and, optionally, the column validation settings.

Additional Column Settings unique to a number site column:

  1. Limits allow you to specify the minimum and maximum value allowed. If the user enters a value outside of the bounds a message will be displayed along with the pre-defined limits.
  2. Decimals allow you to designate the number of decimal places. By default this is set to Automatic which can render different displays for each value.
  3. Default Value allows you to enter an initial numeric value.
  4. Percentage designate whether the number should be shown as a percentage.