Problem with number vs text format

Casey new

I have a column in which some numbers are recognized as such and can be sorted, while other entries are recognized as text. How can I have all recognized as numbers?

SteyJ

https://community.smartsheet.com/discussion/110055/problem-with-number-vs-text-format

Hi @Casey new

try using a helper column. =VALUE([Column Name]@row)

Hope this helps