Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance

The CONVERT function is part of the Analysis ToolPak Add-In. You'll need to
activate that first.

TOOLS
ADD-INS
Check "Analysis ToolPak"
OK

HTH,
Elkar


"April" wrote:

Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance

Hello, April!
You wrote on Thu, 2 Nov 2006 20:45:57 -0000:

A I am trying to convert a cell from metre to ft. The formula
A I use is =convert(C1,"m","ft"). This results in #NAME? If
A I put a number in place of C1, the formula still does not
A work.

A I'd appreciate it if someone could let me with why this is
A happening.

Did you try HELP? The reason for getting #NAME is specifically
mentioned: you don't have the Analysis Toolpack installed.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Convert is part of the Analysis ToolPak add-in. It returns #NAME because the
add-in is not present and Excel does not recognise the function.

--
Ian
--
"April" wrote in message
...
Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance

ToolsAdd-insCheckmark in Analysis ToolPak to load it.

The ATP contains the CONVERT function.

If you had looked for "convert" in Help you would have seen the warning about
#NAME? and the ATP.


Gord Dibben MS Excel MVP

On Thu, 2 Nov 2006 20:45:57 -0000, "April" wrote:

Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance

Of course, you could just use this formula.....

=C1*3.280839895

"April" wrote:

Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance