How do I convert decimal to feet and inches
 

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.

How do I convert decimal to feet and inches
 

=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" 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.

How do I convert decimal to feet and inches
 

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.

How do I convert decimal to feet and inches
 

Genius! Thank you this worked great.

"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.

How do I convert decimal to feet and inches
 

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.

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.