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.