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