R Rodney Sergent Aug 11, 2006 #1 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")?
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")?
D Dave Peterson Aug 11, 2006 #2 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>.)
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>.)
