Is there a formula to convert inches to feet? (Ex: 67" to 5'7" and 75" to 6'3")
S Shannon Apr 25, 2006 #1 Is there a formula to convert inches to feet? (Ex: 67" to 5'7" and 75" to 6'3")
D David Billigmeier Apr 25, 2006 #2 Assume cell A1, change to fit your data: =INT(A1/12)&"'"&MOD(A1,12)&""""
B Bernard Liengme Apr 25, 2006 #4 Use the formula =A1/12 and format the cell with custom format # ??/12 best wishes
