How to sort numeric SharePoint field
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.