On 2/15/2010 1:41 PM, David Biddulph wrote:
=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 ,
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


David's formula is precise, but it's going to show 6.22 inches rather
than 6.25 inches. 6.22, of course, is the correct answer to two decimal
places.
The convert function only works between two units of measurement, not
among three.

Bill