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.


--
Kevin Vaughn


"EXCEL "CONVERT" FUNCTION" wrote:

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.

You have to have the analysis ToolPak installed for this function to work.
To do this:

<Tools
<Add-Ins...
Check Analysis ToolPak


--
Regards,
Dave


"EXCEL "CONVERT" FUNCTION" wrote:

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.