View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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 ?