How do I convert Meters to Feet and Inches?

[Zorba.Eisenhower@gmail.com]

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

[Dave R.]

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 S@discussions.microsoft.com> wrote in message
news:51ED3A06-943C-4787-A75F-296B46B7D46E@microsoft.com...
> 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

[Ron Rosenfeld]

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
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

[Dave R.]

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 S@discussions.microsoft.com> wrote in message
news:51ED3A06-943C-4787-A75F-296B46B7D46E@microsoft.com...
> 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

[Zorba.Eisenhower@gmail.com]

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

[Ron Rosenfeld]

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
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

[Zorba.Eisenhower@gmail.com]

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

[Ron Rosenfeld]

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
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

[Dave R.]

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 S@discussions.microsoft.com> wrote in message
news:51ED3A06-943C-4787-A75F-296B46B7D46E@microsoft.com...
> 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

[Ron Rosenfeld]

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
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

[Dave R.]

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 S@discussions.microsoft.com> wrote in message
news:51ED3A06-943C-4787-A75F-296B46B7D46E@microsoft.com...
> 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

[Zorba.Eisenhower@gmail.com]

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

[Dave R.]

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 S@discussions.microsoft.com> wrote in message
news:51ED3A06-943C-4787-A75F-296B46B7D46E@microsoft.com...
> 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

[Ron Rosenfeld]

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
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

[Zorba.Eisenhower@gmail.com]

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

[Zorba.Eisenhower@gmail.com]

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

[Dave S]

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

[Ron Rosenfeld]

On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
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

[Dave R.]

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 S@discussions.microsoft.com> wrote in message
news:51ED3A06-943C-4787-A75F-296B46B7D46E@microsoft.com...
> 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

[martin fuller]

When I enter this formular or the one in 'Convert measurements' i.e.
=CONVERT(A2,"M","ft") the return I get is '#NAME?
Why is this and how can I obtain the result that one meter = 3' 3" Etc

Thanking you in anticipation.

"Ron Rosenfeld" wrote:

> On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave S@discussions.microsoft.com>
> 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
>

[Niek Otten]

Tools>Add-ins, check Analysis Toolpak
BTW use lowercase "m"

--
Kind regards,

Niek Otten

"martin fuller" <martinfuller@discussions.microsoft.com> wrote in message
news:635200BC-D9B7-45DC-A017-F17859009798@microsoft.com...
> When I enter this formular or the one in 'Convert measurements' i.e.
> =CONVERT(A2,"M","ft") the return I get is '#NAME?
> Why is this and how can I obtain the result that one meter = 3' 3" Etc
>
> Thanking you in anticipation.
>
> "Ron Rosenfeld" wrote:
>
>> On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave
>> S@discussions.microsoft.com>
>> 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
>>

[martin fuller]

Niek,
Yes the addin was not ticked. Ticked this and it works. Why on earth does
not MS put this on their help pages?!
Many thanks for your help and prompt reply -Thank you

"Niek Otten" wrote:

> Tools>Add-ins, check Analysis Toolpak
> BTW use lowercase "m"
>
> --
> Kind regards,
>
> Niek Otten
>
> "martin fuller" <martinfuller@discussions.microsoft.com> wrote in message
> news:635200BC-D9B7-45DC-A017-F17859009798@microsoft.com...
> > When I enter this formular or the one in 'Convert measurements' i.e.
> > =CONVERT(A2,"M","ft") the return I get is '#NAME?
> > Why is this and how can I obtain the result that one meter = 3' 3" Etc
> >
> > Thanking you in anticipation.
> >
> > "Ron Rosenfeld" wrote:
> >
> >> On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave
> >> S@discussions.microsoft.com>
> >> 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
> >>
>
>
>

[Niek Otten]

I don't know about your HELP, but mine says:

"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

--
Kind regards,

Niek Otten

"martin fuller" <martinfuller@discussions.microsoft.com> wrote in message
news:26C17991-8FB0-49C2-9D3D-1D159038F4DA@microsoft.com...
> Niek,
> Yes the addin was not ticked. Ticked this and it works. Why on earth does
> not MS put this on their help pages?!
> Many thanks for your help and prompt reply -Thank you
>
> "Niek Otten" wrote:
>
>> Tools>Add-ins, check Analysis Toolpak
>> BTW use lowercase "m"
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "martin fuller" <martinfuller@discussions.microsoft.com> wrote in message
>> news:635200BC-D9B7-45DC-A017-F17859009798@microsoft.com...
>> > When I enter this formular or the one in 'Convert measurements' i.e.
>> > =CONVERT(A2,"M","ft") the return I get is '#NAME?
>> > Why is this and how can I obtain the result that one meter = 3' 3" Etc
>> >
>> > Thanking you in anticipation.
>> >
>> > "Ron Rosenfeld" wrote:
>> >
>> >> On Tue, 16 Aug 2005 14:49:02 -0700, Dave S <Dave
>> >> S@discussions.microsoft.com>
>> >> 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
>> >>
>>
>>
>>