How to sort numeric SharePoint field

27. January 2015 0 By admin
How to sort numeric SharePoint field, 5.0 out of 5 based on 1 rating
VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)

Have you ever wanted to have a numeric field to sort the numbers but didn’t need the comma for the digit grouping?

Well, my tip is add a new calculated field which is based on the number field. As the formula add


Add the numbers of “0” of the maximum length of the digits, let’s say your biggest number is 654321 then the formula would look like


This will create leading zeros on numbers like 004321 and makes the list sortable. Modify the view to just display the number field and sort by the new hidden calculated field.