inches converted to feet and inches.

[craigwojo]

Hi everyone,

What formula do I need to convert (an input of inches) inches to (an output of feet with inches, esample 5ft. 2in.) to feet with inches.

Thank you,
Craig

 

[Rick Rothstein]

Give this formula a try...

=INT(A1/12)&"ft."&MOD(A1,12)&"in."

 

[craigwojo]

Thank you so much and very prompt. God bless.