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...
RyanGallant How exactly are you digitising the 'paper' data? Are you typing in everything be hand or is it automated in some way?
If by hand, format the height column to TEXT before you start entering the data. Then Excel will not transform 5-11 to a date. Alternatively, precede the height with an apostrophe. Thus, enter '5-11 .