formula to convert decimal feet to feet inch sixteenths
Is this any good?
=TEXT(INT(D18)," 0 ""feet """)&INT(MOD(D18,1)*12)&"
"&TEXT(MOD(D18*12,1),"0/16")&" inches"
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"tv" wrote in message
...
I would like to write a formula in excel, without using macros, to convert
decimal feet to feet-inch-sixteenths.
Can someone help me ?
|