convert meters to feet/inches
One way:
=INT(CONVERT(A1,"m","ft")) & " feet, " &
TEXT(MOD(CONVERT(A1,"m","in"), 12), "0 ""inches""")
In article ,
Ann wrote:
i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for
example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia
|