[Nic Bitting]

Hi Carl, when I paste in that formula you found I had to manually replace the quotes to get it working – once working it yields some strange results. For example 2.9 decimal feet results in 2 ft 10 3/16 in. That’s tough to follow in an Excel workbook full of dimensions.

I edited the formula to yield a more legible and commonly used format:

=TRIM(INT(MROUND(E33*12,0.0625)/12)&”‘”&”-“&TEXT(MOD(MROUND(E33*12,0.0625),12),”#\”””))

In this example 2.9 decimal feet becomes 2′-11″

Hope this helps.