Forum Discussion
Formatting Feet and Inches in one cell
Hi all, I am working with a spreadsheet of archived baseball team rosters (each year's roster is contained as one sheet in the larger workbook). These were previously on paper, but are now being...
How are you planning on using that height data? If it's purely a data point for sharing (e.g., in a printed roster), then the store-as-text solution Riny_van_Eekelen has proposed is right on target.
If you plan ever to use the data for any sorting or ranking on the basis of height, or calculation of average height of a team, etc., you might want to consider either
- converting the feet to inches and posting height in inches (5' 11" becomes 71"), OR
- using two columns, one for feet, one for inches)
Personally, I'd go for the latter, because that could always be used in a roster listing AND it would serve well as the basis for sorting, averaging, etc.