E
Erik
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.
formats. I need to convert 188.76 inches to feet and inches.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" ins"
T
Toppers
or ...
=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"
=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"
E
Erik
Genius! Thank you this worked great.
Toppers said:or ...
=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"
E
Erik
I need to know if you can add the fractions in 16ths?
D
David Biddulph
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"
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"