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.

Thougts?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!