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
Number and Currency Columns in SharePoint

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 –
Number and Currency Columns in SharePoint

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.


Kristin is a content strategist at Techarex Networks. Kristin follows the B2B technology space closely and loves to write on the latest changes in technology, futuretech and fixes for day to day how to issues. Besides writing Kristin also loves music, moves and skating.

Techarex Networks SharePoint Hosting Solutions provides a best-fit collaborative environment,fetching maximum ROI with our world-class SharePoint hosting plans. Our customized deployment helps you to select business-centric configuration. Experience industry-leading SLAs and dedicated 24X7 support, augmenting business needs with world-class industry-ready SharePoint foundation, enterprise, and custom hosting plans.