CONVERT Function is part of the Analysis ToolPak add-in.

ToolsAdd-ins. Check the ATP.

Help on CONVERT does state you will need the ATP loaded, BTW.

Right up at the top of the page.


Gord Dibben Excel MVP

On Wed, 13 Apr 2005 00:57:42 +0100, Andy wrote:

Hi

I have Office XP which I have updated to SP3. I ran Windows Update the other
day and it offered to check other programs and it recommended some form of
security update for Office which I opted to download. It might be coincidence
but I have a worksheet that contains the CONVERT worksheet function which no
longer works after this update. When I recalculate, I get #### in the boxes
that contain the CONVERT function and when I move the mouse over the box I get
#NAME?. If I try the 'Insert Function' option, CONVERT is not available from
the list and if I copy & paste a CONVERT example from the help function into a
worksheet this fails also. I have uninstalled and reinstalled Office but I
still have this problem. Can anyone help?

Andy