Forum Discussion
romantzlady
Sep 22, 2020Copper Contributor
Excel sorting numbers
I have a lot of documents where I have to sort numbers. I've had no problems with my sort until I updated my office program 3 weeks ago. Now with every number grouping I sort it gives me an inaccur...
Riny_van_Eekelen
Sep 22, 2020Platinum Contributor
romantzlady Can't explain why this started after an update, but your "numbers" are in fact texts and sorted accordingly. Use the VALUE function to convert them to numbers.