Number and Currency Columns in SharePoint
Number column :
A Number column comes with pretty simple and easy-to-do customization options. This column type is extremely useful in cases of lists due to its versatility for calculations or reporting purposes.
Following is the layout for this column type
As per your choice, you can specify a specific range of numbers that can be entered by users. Consider for example, in case you have a column that represents a specific user’s rating of some item, you may have following values –
- Minimum value of 1
- Maximum value of 10
You can very easily configure a Number column to display a particular number of decimal places or say the percentage value irrespective of the format used by a user to enter the information.
Currency column :
A Currency column provides customization options similar to Number column type except that there is one addition as given in following figure –
The Currency column allows users to specify the specific regional format for data display. No direct link exists though between the currency exchange rates and the regional settings.