LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Gord Dibben
 
Posts: n/a
Default CONVERT Function Disappered in Excel

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I convert an Excel file to an Adobe .pdf file by using Ex. pammoore2000 Excel Discussion (Misc queries) 5 March 15th 05 03:51 AM
How to convert excel Docs to pocket excel on my mobile device New User again New Users to Excel 1 March 8th 05 07:02 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. Sapporo Excel Worksheet Functions 3 December 17th 04 02:33 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"