Home » Questions » Computers [ Ask a new question ]

How can I have Excel reorder my rows correctly?

How can I have Excel reorder my rows correctly?

Sorry for the vague question. Let me explain.

Asked by: Guest | Views: 280
Total answers/comments: 2
Guest [Entry]

Split the column into two and sort on the decimals column. This explains how - http://excel.tips.net/Pages/T003836_Sorting_Decimal_Values.html
Guest [Entry]

"Make sure they are stored as text, not numbers (select cells, right click, Format Cells, select ""Text"" in Number tab.)
Data > Sort, make sure Header row is set correctly (look at selected cells), OK
You should now have a dialog asking ""The following sort key may not sort as expected because it contains some numbers formatted as text:"", select ""Sort numbers and numbers stored as text separately""

Once you've done this the sort button on the toolbar/ribbon should work as you want it."