Assume cell A1, change to fit your data:

=INT(A1/12)&"'"&MOD(A1,12)&""""

--
Regards,
Dave


"Shannon" wrote:

Is there a formula to convert inches to feet? (Ex: 67" to 5'7" and 75" to 6'3")