Forum Discussion
Ordering Fractions
Hello All, I have a sorting issue I have been trying to work out and I could use a little assistance. I have Fractions of measurements, starting at 1/32" going to 1". For some reason when I...
I guess you keep fractions as texts, thus they are sorted in alphabetical order as texts.
If you apply custom number format to cell(s) as Fraction and enter fractions here (just type 13/16, Enter) they will be kept as numbers and sorted as numbers