Can I get Sharepoint to sort by numeric order? form low to high with numbers from 1 to 9000

%3CLINGO-SUB%20id%3D%22lingo-sub-1735487%22%20slang%3D%22en-US%22%3ECan%20I%20get%20Sharepoint%20to%20sort%20by%20numeric%20order%3F%20form%20low%20to%20high%20with%20numbers%20from%201%20to%209000%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1735487%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20sharepoint%20library%20sorts%20by%20the%20first%20digits%20instead%20of%20numeric%20order%3A%3CBR%20%2F%3EExample%3C%2FP%3E%3CP%3E99%20-%20file%3C%2FP%3E%3CP%3E100%20-%20file%3CBR%20%2F%3E%3CSTRONG%3E1202%20-%20file%3CBR%20%2F%3E1215%20-%20file%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E123%20-%20file%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20I%20make%20it%20sort%3A%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E99%20-%20file%3CBR%20%2F%3E100%20-%20file%3CBR%20%2F%3E101%20-%20file%3CBR%20%2F%3E123%20-%20file%3CBR%20%2F%3E%3CSTRONG%3E1202%20-%20file%3CBR%20%2F%3E1215%20-%20file%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anybody%20tell%20me%20how%20to%20fix%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1735487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1735608%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20get%20Sharepoint%20to%20sort%20by%20numeric%20order%3F%20form%20low%20to%20high%20with%20numbers%20from%201%20to%209000%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1735608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397476%22%20target%3D%22_blank%22%3E%40Marinpetersen%3C%2FA%3E%26nbsp%3Byou%20can%20only%20sort%20SharePoint%20library%20views%20in%20numeric%20order%20on%20a%20number%20field.%20Text%20fields%20will%20always%20sort%20alphabetically%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 - file
101 - file
123 - file
1202 - file
1215 - file


Can anybody tell me how to fix this?

3 Replies
Highlighted

@Marinpetersen you can only sort SharePoint library views in numeric order on a number field. Text fields will always sort alphabetically

Highlighted
Highlighted

@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.