Hi Guys,

For some reason my Convert Function doesn't do anything for me, can anyone
please give some idea about how I can solve this issue?

Thanks in advance.

What's the issue? You give no detail other than something is not working as
you expect it to.
--
Brevity is the soul of wit.


"2007-User" wrote:

Hi Guys,

For some reason my Convert Function doesn't do anything for me, can anyone
please give some idea about how I can solve this issue?

Thanks in advance.

For example:
=convert(100,"mi","km")
gives me: #NAME?


"Dave F" wrote in message
...
What's the issue? You give no detail other than something is not working
as
you expect it to.
--
Brevity is the soul of wit.


"2007-User" wrote:

Hi Guys,

For some reason my Convert Function doesn't do anything for me, can
anyone
please give some idea about how I can solve this issue?

Thanks in advance.

The first thing is to check that you've got the Analysis ToolPak loaded
(Tools/ Addins).
Even then, Excel will occasionally fail to start up the Analysis ToolPak
functions (it has just failed in that way for me);
http://support.microsoft.com/default.aspx/kb/291058 is the official answer,
but I found I had to close Excel and open it again.
--
David Biddulph

"2007-User" wrote in message
...
For example:
=convert(100,"mi","km")
gives me: #NAME?


"Dave F" wrote in message
...
What's the issue? You give no detail other than something is not working
as
you expect it to.
--
Brevity is the soul of wit.


"2007-User" wrote:

Hi Guys,

For some reason my Convert Function doesn't do anything for me, can
anyone
please give some idea about how I can solve this issue?

Thanks in advance.

I found it, I should add analysis took pack ...

Thanks anyway

"Dave F" wrote in message
...
What's the issue? You give no detail other than something is not working
as
you expect it to.
--
Brevity is the soul of wit.


"2007-User" wrote:

Hi Guys,

For some reason my Convert Function doesn't do anything for me, can
anyone
please give some idea about how I can solve this issue?

Thanks in advance.