FORMAT FOR FEET AN DINCHES

  • Thread starter Thread starter Roys31
  • Start date Start date
1) Suppose A1 contains a value such as 63 to represent 63 inches, then the
formula
=INT(A1/12) & " ft. " & MOD(A1,12) & " in."
will display 5 ft 3 in. But this is TEXT and you can do not math on it

2) I find it better to enter, for example, 5 3/12 and to format the range
with custom format # ?/12
You can do all the math you need on such cells

best wishes
 
Back
Top