Convert function not working

[Rao Ratan Singh]

Sir/Mam,
I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it
is giving #name?

I m using office 2003.

yours

Rao Ratan Singh

[JON JON]

From help file:

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

1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
4..
"Rao Ratan Singh" <[email protected]> wrote in message
news:[email protected]...
> Sir/Mam,
> I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it
> is giving #name?
>
> I m using office 2003.
>
> yours
>
> Rao Ratan Singh

[paul]

if you get the #n/a error it means you are using incompatible units.The
example in help is actually the one below,how can you convert feet to seconds?
--
paul
[email protected]
remove nospam for email addy!



"JON JON" wrote:

> From help file:
>
> If this function is not available, and returns the #NAME? error, install and
> load the Analysis ToolPak add-in.
> How?
>
> 1.. On the Tools menu, click Add-Ins.
> 2.. In the Add-Ins available list, select the Analysis ToolPak box, and
> then click OK.
> 3.. If necessary, follow the instructions in the setup program.
> 4..
> "Rao Ratan Singh" <[email protected]> wrote in message
> news:[email protected]...
> > Sir/Mam,
> > I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it
> > is giving #name?
> >
> > I m using office 2003.
> >
> > yours
> >
> > Rao Ratan Singh
>
>
>

[Bondi]

Rao Ratan Singh wrote:
> Sir/Mam,
> I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it
> is giving #name?
>
> I m using office 2003.
>
> yours
>
> Rao Ratan Singh

Hi Rao,

It might be that Excel is not recognising the function. This might be
because you have not loaded the Analysis ToolPak Add-In.

Try to go to Tools -> Add-Inns and here checkmark the Analysis ToolPak
Option then press OK.

I do have to agree with Paul though and say that i think that even
with Analysis ToolPak loaded converting feet to seconds will be quiet a
challange.

Regards,
Bondi