• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can you format cells to show height in feet and inches?

Im_Offset

Member
Hello again to all you Extremely Excellent Excel Extraordinaires!

I'm wanting to format a column to display a persons height in feet and inches (i.e. 5' 10" or 6' 0"). I realize I could do this as a text entry, but I also want to be able to sort the data based on a person's height (ex: shortest to tallest).

How can I do that?

Thank you for helping me in advance because:
Im_Offset
:)
 
How are you entering your data? Inches, ie. 72 inches or decimal of feet. ie. 5.75 feet or some other manner.
 
Back
Top