Sorting issue

I'm having an advanced sorting issue. When sorting by a custom list I made it won't work correctly. Instead of listing 4, 4.5, 5, etc it list 4.5 before 4. Has anyone had issues with this? Spreadsheet attached.

Well if you notice not all of the cases are like that in column C. It only does it starting at 4" and up. The rest of the values sort properly. I did something before which let me sort them accordingly. On the "Inputs" tab I've assigned those values as a custom sort list. I believe that should dictate which values get sorted in which way unless I'm wrong.

Originally Posted by FDibbins

If you mean column C, then your sort is not working because your data is actually text, not numeric. You need to remove the " from the end, to make it numbers, then try again