0)"""" ，"ft") To get feet and inches as text (e.g.，1)*12， use this formula to get feet: =A1/30.48 Using the CONVERT function: =CONVERT(A1，"cm"， Excel/Google Sheets Formulas If your centimeter value is in cell A1， "5'9\""): =INT(A1/30.48)"'"ROUND(MOD(A1/30.48，。