=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches"

Here I'm converting the value in A1 from meters to feet using 3.2808399 feet
per meter. The first part truncates the decimal protion and adds, "feet" and
the second part truncates the integer portion and convert it to inches and
adds "inches"

"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