Whilst I concede that yours is much better than mine, it can still be
improved upon <vbg

=INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16 ""in""")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Toppers" wrote in message
...
Decimal value in A1, formula in B1:


=INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"

A1=2.345 (ft)

B1=2 ft 4 2/16 in

HTH

"tv" wrote:


I would like to write a formula in excel, without using macros, to
convert
decimal feet to feet-inch-sixteenths.

Can someone help me ?