Feet and Inches Format
Posted by David on September 05, 2001 11:29 PM
Does anyone know how I can format a cell for feet and inches?
Posted by Paul on September 06, 2001 5:29 AM
=ROUNDDOWN(A1/12,0)&" feet "&A1-12*ROUNDDOWN(A1/12,0)&" inches" If you put the inches in cell A1 this will give you feet and inches
Posted by lenze on September 06, 2001 6:36 AM
http://www.cpearson.com/excel/fractional.htm
