Forum Discussion
Can I get Sharepoint to sort by numeric order? form low to high with numbers from 1 to 9000
My sharepoint library sorts by the first digits instead of numeric order: Example 99 - file 100 - file 1202 - file 1215 - file 123 - file How do I make it sort: Example: 99 - file 100 - f...
Marinpetersen you can only sort SharePoint library views in numeric order on a number field. Text fields will always sort alphabetically
Allright thank you,
Marinpetersen You could create a second column that just contains the number and sort on that. You should be able to keep it hidden and still sort on it in the view settings. You MIGHT even be able to create that second column as a Calculated column based on your column so you don't have to worry about data entry.
I'm not 100% on the calculated column working out, but it's probably worth a shot.
