cfg
4/28/2016 - 3:19 PM
Excel: Format inches as Feet' Inches"
Excel: Format inches as Feet' Inches"
=FLOOR(A1/12,1) & """ " & ROUND( 12*((A1/12)-FLOOR(A1/12,1)), 1) & "'"Excel: Format inches as Feet' Inches"
=FLOOR(A1/12,1) & """ " & ROUND( 12*((A1/12)-FLOOR(A1/12,1)), 1) & "'"