uncorrect sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-2306707%22%20slang%3D%22en-US%22%3Euncorrect%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306707%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20need%20to%20sort%20data%20but%20when%20I%20try%20Excel%20gives%20me%20wrong%20results.%20I%20have%20data%20from%202000%20to%200%20and%20it%20starts%20the%20sorting%20(decreasing)%20with%20the%20highest%20left%20value%3A%20so%20it%20starts%20with%209%20(both%20900s%20and%2090s)%2C%20then%20with%208%20(both%20800s%20and%2080s)%20and%20the%20other.%20When%20it%20comes%20to%202%20it%20includes%202000s%2C%20200s%20and%2020s%20and%20so%20on.%20I%20have%20already%20worked%20with%20this%20function%2C%20so%20it%20is%20quite%20odd%20for%20me.%20Is%20it%20a%20problem%20of%20formatting%3F%20Thank%20you%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2306707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2306730%22%20slang%3D%22en-US%22%3ERe%3A%20uncorrect%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1040724%22%20target%3D%22_blank%22%3E%40alexros980%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20data%20are%20texts%20or%20numbers%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I need to sort data but when I try Excel gives me wrong results. I have data from 2000 to 0 and it starts the sorting (decreasing) with the highest left value: so it starts with 9 (both 900s and 90s), then with 8 (both 800s and 80s) and the other. When it comes to 2 it includes 2000s, 200s and 20s and so on. I have already worked with this function, so it is quite odd for me. Is it a problem of formatting? Thank you a lot

2 Replies

@alexros980 

Your data are texts or numbers?

@alexros980 

That makes me suspect the data are seen as text by Excel.

Try the following:

  • Select the range.
  • Set the number formatting to General or to Number.
  • On the Data tab of the ribbon, select Text to Columns.
  • Click Finish.

Does that make a difference?