How do I convert decimal to feet and inches
Yes.
If you want the input in 16ths, just use something like 188 13/16.
If you want the output in 16ths, change the formula from
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" in" to
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"# ??/16")&" in"
--
David Biddulph
"Erik" wrote in message
...
I need to know if you can add the fractions in 16ths?
"Toppers" wrote:
or ...
=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"
"Erik" wrote:
I've seen the other posts but they deal with smaller numbers or
different
formats. I need to convert 188.76 inches to feet and inches.
|