Converting decimal feet to feet and inches
Posted by Jim Rich on January 23, 2001 4:14 PM
I have a cell with total inches as "123", I would like to convert to feet and inches.
I tried tip 012.shtml but could not get it to work, or I don't know how to inter and run a macro. Could you give me more detale. Thanks, Jim
Posted by Mark W. on January 23, 2001 5:25 PM
=TEXT(123/12,"0")&" ft "&MOD(123,12)&" in"
