=INT(A1*1000/(25.4*12))&"' "&ROUND(MOD(A1*1000/25.4,12),2)&""""
--
David Biddulph


matt wrote:
One problem that I have while doing this is that I'd like the results
to be more precise.

I would like 12.35 meters to come out as 40' 6.25"

I'd even like to have the ' and " instead of feet/inches. Is all
that a possibility?

Thanks for help.

"sb1920alk" wrote:

=CONVERT(VALUE(SUBSTITUTE(A1," feet",""))+VALUE(SUBSTITUTE(B1,"
inches",""))/12,"ft","m")

"Ann" wrote:

and if i was to reverse this formula? from feet and inches back to
meters? if feet is in a1 and inches is in b1
thanks guys

"JE McGimpsey" wrote:

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