Issue a format cell with Feet, Inches and decimal

Question

I have a hard time to format cell with Feet, Inch(es) and decimal (.##)##' ##.##" (Example: 100' 9.25")I have work the field event with distance (shot put, discus, hammer and javelin) and height (high jump and pole vault) in English measurement&nbsp;Shot PutRank.&nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp;Grade. Distance.&nbsp; &nbsp; &nbsp; Year. Notes1.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John Doe&nbsp; &nbsp;11&nbsp; &nbsp; &nbsp; &nbsp; 40' 1.75".&nbsp; &nbsp; &nbsp;1999. State2.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dan Doe.&nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;35' 1.5"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2001. League3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Tyler Doe.&nbsp; &nbsp;12.&nbsp; &nbsp; &nbsp; &nbsp;35' 10.25".&nbsp; &nbsp; &nbsp;1991. Invite4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sam Doe.&nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; 35' 0"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1984. State&nbsp;I have problem with column (see Distance) numbers try to 'sort' like rankings and i can't solve the format cell and custom.Please help me. Thank you!

hansvogelaar · Answer

deafkidrunner&nbsp;
I'd add a column with the distance either in inches (i.e. 2'8" = 32 inches) or in metres, and sort on that column.

Forum Discussion

Issue a format cell with Feet, Inches and decimal

1 Reply