I am having a hard time getting a SharePoint 2013 list to sort in the correct order. We enter strings like this example 50-00-0. Then we want to split this into three columns so we may order them correctly. However when we try to get the first set of numbers using the calculated formula function:
=INT(LEFT([CAS #],LEN([CAS #])-5))
The calculated column still sorts as a string rather than as a number
I have also tried various other numeric functions to try and get the column to sort as a number, for example the VALUE function and adding 0 to the formula - Neither of these worked either.