Sort on a fractional number in a text field

[Exsubsailor]

Trying to sort (diameters) a fractional number in a text field. format is "1-1/2". Some numbers are just whole numbers some are fractions. Anyone have the code for this?

[andy49]

Are there many different options?

[andy49]

If not. This looks almost exactly what you need

https://groups.google.com/forum/m/?h...U/ajMfaPFoVisJ

[Exsubsailor]

Thank you...I'll adjust it to use the hyphen instead of the space.