Thread
:
How do I convert Meters to Feet and Inches?
View Single Post
#
2
Dave R.
Posts: n/a
What I looked has 1 meter = 3.28 feet, not 3.5 feet. Put meters in E8 and
use this formula:
=INT(E8*3.28)&" "&TEXT(MOD(E8*3.28,1),"##/##")
"Dave S" <Dave
wrote in message
...
I need to convert Meters to Feet and Inch measurments. I need it in
fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.
Ex. 1 Meter
= 3 1/2 Feet
Reply With Quote