MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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