In my excel spreadsheet, I am trying to randomly sort a large list. I am doing this by adding in a new column to my table. This table is assigned a random integer between 1 and 10. This is done by =FLOOR(10 * RAND(), 1). Then I want to sort this list of numbers from smallest to largest.
All of this is working except the sorting. When I try to sort it, excel changes the order of the numbers slightly, but it is not from smallest to largest.
Any ideas on how to fix this?