change decimal to feet and inches
Gary''s wrote on Fri, 22 Feb 2008 11:22:01 -0800:
GsS =INT(A1)&"' "&INT(12*(A1-INT(A1)))&"""
GsS "&TEXT(MOD(12*(A1-INT(A1)),1),"##/##")
GsS which will display as 12" 1" 1/5
GsS If you need the reverse, put the feet and inches into
GsS separate cells to make the math easier
GsS --
GsS Gary''s Student - gsnu200770
GsS "Eyde" wrote:
?? I need to know how to convert decimal numbers that could
?? at eny given time be zero decimal places up to three
?? decimal places (ie 5, 3.5, 5.33, 12.713) to feet and
?? inches (ie 5'-0", 3'-6", 5'-4", 12'-8 1/2") this excel
?? formula is going to be linked with an AutoCad table can
?? any one help me with this?
I managed something your formula when I tried tho' I was content
with an integral number of inches, even if I had to relearn a
number of functions (as usual), but then I wondered if it would
be possible to devise a custom format and I'm currently stuck
:-)
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
|