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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Roys31" wrote in message
...
Is there any way to easily format for feet and inche?