Why is ther no "Convert" function available in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use a convert function and always results in "#NAME?". So I
kept using Microsoft Excel Help to figure this out and Microsoft Excel Help
would show how to use the function. I followed its instruction and result was
the same. I then showed all the functions available for excel and the
"convert" function is not on the list. I also checked on previous version of
Excel and results are the same - no "convert" function in the program.
 
the #Name error indicates (in this instance) that the function is not
available. The following is copied from Excel Help re the convert function:

If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using Add-Ins on the Tools menu.
 
You have to have the analysis ToolPak installed for this function to work.
To do this:

<Tools>
<Add-Ins...>
Check Analysis ToolPak
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 5
How can I migrate MBOX to PST? 2
Convert Decimal fractions to binary and vice versa 1
CONVERT function for Excel 2003 2
How do I use Excel to convert feet to kilometers? 3
Converting Metric to Imperial 8
convert figures into words on Microsft Excel 3
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7

Back
Top