sort numers

%3CLINGO-SUB%20id%3D%22lingo-sub-1894271%22%20slang%3D%22en-US%22%3Esort%20numers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894271%22%20slang%3D%22en-US%22%3Ehi%20i%20would%20like%20to%20know%20how%20i%20can%20sort%20the%20numbers%2C%201%20to%201000.%20if%20I%20put%20them%20in%20excel%20in%20there%20in%20any%20order.%20my%20problem%20is%20if%20I%20push%2C%20the%20sort%20button%2C%20it%20will%20sort%20so%201%20and%2010%20and%20100%20is%20together%20with%201000%20and%202%20is%20with%2020%20and%20200%20and%20so%20on.%20and%20you%20know%20that%20is%20not%20right%3CBR%20%2F%3Eas%20you%20see%20on%20the%20attached%20fill%2C%20this%20is%20how%20I%20can%20manage%20to%20sort%20it%2C%20and%20this%20is%20not%20right.%3CBR%20%2F%3Ehow%20do%20I%20make%20it%20right%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1894271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1894373%22%20slang%3D%22en-US%22%3ERe%3A%20sort%20numers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871523%22%20target%3D%22_blank%22%3E%40stanleymkay%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20texts%20in%20your%20column%2C%20not%20numbers%2C%20and%20they%20are%20sorted%20as%20texts.%20If%20you%20need%20numbers%2C%20not%20texts%2C%20convert%20them%20to%20numbers%20first.%20On%20ribbon%20Data-%26gt%3BText%20to%20Columns%2C%20after%20that%20by%20default.%3C%2FP%3E%0A%3CP%3EPlus%20be%20sure%20yor%20decimal%20separator%20is%20dot%20and%20column%20A%20is%20in%20General%20or%20Number%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
hi i would like to know how i can sort the numbers, 1 to 1000. if I put them in excel in there in any order. my problem is if I push, the sort button, it will sort so 1 and 10 and 100 is together with 1000 and 2 is with 20 and 200 and so on. and you know that is not right
as you see on the attached fill, this is how I can manage to sort it, and this is not right.
how do I make it right?
3 Replies

@stanleymkay 

There are texts in your column, not numbers, and they are sorted as texts. If you need numbers, not texts, convert them to numbers first. On ribbon Data->Text to Columns, after that by default.

Plus be sure yor decimal separator is dot and column A is in General or Number format.

ok so what you say is that, what to me looks like numbers, are not?

@stanleymkay 

Here

image.png

in A1 is text (number stored as text), by default it aligned to the left. In A2 is number.

 

I guess in your case all are texts, to be sure it is better to check sample file.