Decimal to feet/inch/fractional inch conversion

[Rodney Sergent]

Is there a way that a cell can be formatted to convert a decimal of a foot
(2.78') to feet/inches format (2'-9 3/8")?

 

[Dave Peterson]

Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/fractex1.htm

I'd use formula e3 with a helper cell.

Put 2.78 in B1, put =B1*12 in A1
and the formula in C1.

(I'd be too lazy to convert the formula -- but maybe you're not as lazy as me
<bg>.)