Issue with converting a text/number to a number then getting it to sort properly
I took number off the front of a text string in a column using the =Left command and the number came over as text. Using =Value I converted that to a number. When I went to sort the numbers everything was out of order, zeros were random and the string start 1, 3, 4, 5 and then was grouped but appeared random.
Help Article Resources
Check out the Formula Handbook template!