Excel won't recognize CONVERT() function??

Posted by Aron on January 15, 2002 2:57 PM

I went back to a worksheet I was using recently and it will no longer recognize the CONVERT() function.

Any ideas at all?

Aron

Posted by IML on January 15, 2002 3:00 PM

Was this is in a second instance of excel being open, or did you de-install the analysis tool pak?

Posted by Barrie Davidson on January 15, 2002 3:01 PM

From Excel's help:

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.

Hope this helps you out.
Regards,
BarrieBarrie Davidson

Posted by Aron on January 15, 2002 11:48 PM

oops. I'd removed the Analysis add-in. Thanks!!