Feet to Inches

Posted by Elknih on February 28, 2001 6:17 AM

I'm trying to convert decimal feet to feet and inches and fractions thereof. I saw the LenText and Feet tip ( Tip #012) But I'm still kinda lost

I'm just learning and missing something simple.

guys are waiting .........

Thanx

Posted by GregA on February 28, 2001 7:06 AM

This formula will do it for you (assumes the decimal value is in A6):
TRIM(TEXT(INT(A6),0)&"' "&TEXT(MOD(A6,1)*12,"# ?/8")&"""")

The "# ?/8" expresses the fractions as eighths -- you can change the 8 to another number (if you make it 2 digits, add another ? to the numberator) or you can change it to a ? and Excel will determine the lowest common denominator to use. The TRIM()removes the extra spaces between the las number and the " if there isn't a fraction -- if you want the numbers to align, take out TRIM(),

Posted by Aladin Akyurek on February 28, 2001 7:06 AM

See:

8918.html

Posted by Elknih on February 28, 2001 8:33 AM

Thanks for ALL the help ...

I used the post GregA formula, and modified it slightly for accuracy I need as :

=TRIM(TEXT(INT(B16),0)&"' "&TEXT(MOD(B16,1)*12,"??/16")&"""")

However when I run it using my "large #'s, I'm still missing a small aspect. It returns a figure as : 5143' 20/16"
from: 5143.1050

what I need to end w/ is 5143' 1-1/4"

any help???

Thanx to ALL !

I have no idea what that is...

Posted by Elknih on February 28, 2001 8:48 AM

Sorry GregA.... :(

I went back and triple checked ur method and I see that it IS correct. My bad..

Thanks again.

Elknih

Posted by GregA on February 28, 2001 4:23 PM

(NT) Glad it worked