How do I convert Meters to Feet and Inches?

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 [email protected]> wrote in message
news:[email protected]...
> 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

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave [email protected]>
wrote:

>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

I assume you want the reduced fraction. i.e. you would want 1/2 rather than
8/32.

If you have the Analysis Tool Pak installed, you may use this formula:

=mROUND(convert(A1,"m","ft"),1/32)

And custom format the cell as fraction with up to 2 digits.

If you don't have or want the ATP installed, then:

=ROUND(A1*3.28084*32,0)/32

(still formatting the cell as fraction with up to 2 digits).


--ron

Look at the CONVERT function in the analysis toolpak.

Here's an extract from the Excel 2003 Help file:

Distance From_unit or to_unit
Meter "m"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica (1/72 in.) "Pica"


Pip pip
Zorba

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 [email protected]> wrote in message
news:[email protected]...
> 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

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave [email protected]>
wrote:

>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

I assume you want the reduced fraction. i.e. you would want 1/2 rather than
8/32.

If you have the Analysis Tool Pak installed, you may use this formula:

=mROUND(convert(A1,"m","ft"),1/32)

And custom format the cell as fraction with up to 2 digits.

If you don't have or want the ATP installed, then:

=ROUND(A1*3.28084*32,0)/32

(still formatting the cell as fraction with up to 2 digits).


--ron

Look at the CONVERT function in the analysis toolpak.

Here's an extract from the Excel 2003 Help file:

Distance From_unit or to_unit
Meter "m"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica (1/72 in.) "Pica"


Pip pip
Zorba

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

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 [email protected]> wrote in message
news:[email protected]...
> 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

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave [email protected]>
wrote:

>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

I assume you want the reduced fraction. i.e. you would want 1/2 rather than
8/32.

If you have the Analysis Tool Pak installed, you may use this formula:

=mROUND(convert(A1,"m","ft"),1/32)

And custom format the cell as fraction with up to 2 digits.

If you don't have or want the ATP installed, then:

=ROUND(A1*3.28084*32,0)/32

(still formatting the cell as fraction with up to 2 digits).


--ron

Look at the CONVERT function in the analysis toolpak.

Here's an extract from the Excel 2003 Help file:

Distance From_unit or to_unit
Meter "m"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica (1/72 in.) "Pica"


Pip pip
Zorba