ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert Founction (https://www.excelbanter.com/excel-discussion-misc-queries/127542-convert-founction.html)

2007-User

Convert Founction
 
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.



Dave F

Convert Founction
 
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.




2007-User

Convert Founction
 
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.






2007-User

Convert Founction
 
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.






David Biddulph

Convert Founction
 
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.









All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com