Monatsarchive: Januar 2015

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

Formula
=TEXT([Fieldname],”0”) 

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

Formula
=TEXT([Fieldname],”000000”) 

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.