If A1 has the value 2, use
CONCATENATE(TEXT(INT(CONVERT(A1,"m","ft")),"####0" ),
" feet,",TEXT(MOD(INT(CONVERT(A1,"m","in")),12),"#0" )," inches")
to give you 6 feet, 6 inches
If A1 has 100, you will get 328 feet, 1 inches
Ignores the fraction of an inch
On Mon, 15 Jun 2015 05:35:25 -0700 (PDT),
wrote:
On Thursday, 5 June 2008 01:39:03 UTC+5:30, 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
100*100m= howmanyfeets