Hello,

I have attached a file with the column "distance" where I use the LEFT formula to remove the numbers from the text string adjacent to "distance" column. I want to sort using distance but I cannot convert the cells in the "distance" column to numbers to be able to sort in excel. I have tried paste special-values to convert the cells to numbers, and I have multiplied the left formula in distance column by 1, but I still cannot sort the data and I get a #value when I multiply by 1.

Please tell me what I need to do to convert the cells to numbers to be able to convert. Thanks,

P.S. When I convert the "distance" column to from letters to numbers using paste special and then I sort the column from highest to lowest, the numbers do not sort in correct order. They sort to 0, and then they sort from highest to lowest starting from 0 all over again . Please try to sort the distance column after you convert it to numbers; I don't understand why it is sort to 0 and then back up.

Jeremy

Attached Files

Numbers 2.xlsx (24.7 KB, 14 views)