Sorting a mixed text/number Column by number on a Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1942382%22%20slang%3D%22en-US%22%3ESorting%20a%20mixed%20text%2Fnumber%20Column%20by%20number%20on%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1942382%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20on%20a%20Mac%20and%20trying%20to%20sort%20a%20column%20by%20numbers%20but%20it's%20not%20sorting%20how%20you%20would%20actually%20count.%26nbsp%3B%20For%20instance%2C%20instead%20of%20sorting%201%20through%2020%20as%20you'd%20normally%20count%2C%20it%20is%20sorting%201%2C%2010%2C%2011%2C%2012%2C%2013%2C%2014%2C%2015%2C%2016%2C%2017%2C%2018%2C%2019%2C%202%2C%2020%2C%203%2C%204%2C%205%2C%206%2C%207%2C%208%2C%209.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20column%20is%20mixed%20text%2Fnumber%20and%20I've%20tried%20selecting%20the%20column%20as%20text%2C%20number%2C%20general%2C%20etc.%20and%20it%20doesn't%20change%20the%20sorting%20to%20a%20natural%20count%20style.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1942382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1943346%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20a%20mixed%20text%2Fnumber%20Column%20by%20number%20on%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F886278%22%20target%3D%22_blank%22%3E%40AWitt77%3C%2FA%3E%26nbsp%3BYou%20need%20to%20transform%20all%20entries%20in%20the%20column%20to%20real%20numbers.%20Simply%20setting%20the%20format%20is%20not%20sufficient.%20Select%20the%20column%20with%20the%20%22numbers%22.%20On%20the%20Data%20ribbon%20select%20%22Text%20to%20Columns%22.%3C%2FP%3E%3CP%3EClick%20%22Next%22.%20until%20you%20reach%20step%203%20of%203%2C%20Make%20sure%20%26nbsp%3B%22General%22%20is%20selected.%20Press%20Finish.%20Now%20you%20will%20have%20real%20numbers%20that%20can%20be%20sorted%20as%20you%20expect%20then%20to%20be.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm on a Mac and trying to sort a column by numbers but it's not sorting how you would actually count.  For instance, instead of sorting 1 through 20 as you'd normally count, it is sorting 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20, 3, 4, 5, 6, 7, 8, 9.

 

The column is mixed text/number and I've tried selecting the column as text, number, general, etc. and it doesn't change the sorting to a natural count style.

 

Any help is appreciated, thank you!

2 Replies

@AWitt77 You need to transform all entries in the column to real numbers. Simply setting the format is not sufficient. Select the column with the "numbers". On the Data ribbon select "Text to Columns".

Click "Next". until you reach step 3 of 3, Make sure  "General" is selected. Press Finish. Now you will have real numbers that can be sorted as you expect then to be.

@Riny_van_Eekelenthank you so much for the help!!!