converting decimals

Posted by MIKE RICHARD on May 08, 2001 9:06 AM

Need Help Converting Decimals to foot/inch
ex. 29.56' to 29'-6 3/4"

Posted by Kevin James on May 08, 2001 9:13 AM

Hi Mike,

Go to:

whitehare.topcities.com/Downloads.html

Download file: DisplayFractions.xls

Kevin

Posted by Barrie Davidson on May 08, 2001 9:24 AM

Try this formula (assumes that you have the number in cell A1 and that it is a number, not text).

=INT(A1)&"' - "&TEXT((A1-INT(A1))*12,"#_??/??")&""""

Barrie

Posted by Kevin James on May 08, 2001 9:45 AM

Barrie,

Wonderful! Would mind if I include that in my posting as long as I give full credits to you?

whitehare.topcities.com/DisplayFractions.xls

Kevin

Posted by Barrie Davidson on May 08, 2001 9:59 AM

Posting the formula

Go right ahead (I'm also posting it on my website). And, thanks for the compliment.