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 ?