Convert decimal feet

[taoist]

How do you convert decimal feet to fractional feet and inches?

Ex: 12.25' to 12'-3" or 9.63' to 9' - 7 9/16"

 

[rs2k]

Taoist, Welcome to the board.
Have a look at this link, I think it does what you are asking.

http://www.mrexcel.com/board2/viewtopic.php?t=124224&highlight=convert+fractions

If you do a search for fractions, conversions etc... on this board, it throws some useful stuff back.

Colin.

 

[Andrew Poulsom]

Welcome to the Board.

Try eg:

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

where A1 contains the decimal feet.

 

[taoist]

Thank You everyone for welcoming me to the board. I appreciate your quick responses. I will give the formulas a try and checl out the article on the board.

taoist

 

[taoist]

Thanks for the format tip Andrew! It worked great. I do have a question though. When using this format if there are no fractions the " is placed to far to the right of the inches number. Is there a way to have the " mark float or adjust itiself to the inches number?

taoist

 

[Andrew Poulsom]

The formula is getting a bit long ...

=INT(A1)&"'"&IF((A1-INT(A1))," - "&INT((A1-INT(A1))*12)&IF(((A1-INT(A1))*12)-INT((A1-INT(A1))*12),TEXT(((A1-INT(A1))*12)-INT((A1-INT(A1))*12)," ?/16"),"")&"""","")