View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

VPH

If you read the 2002 Help on CONVERT carefully you will see this........

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

To load the Analysis Toolpak go to ToolsAdd-ins and checkmark the ATP.


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 08:59:01 -0800, VPH wrote:

Although the convert function is listed in excel 2002 help it is not
available from the insert formula command and it does't work in excel 2002.
s there a way to get it to work?
=CONVERT(A2,"cm","in") Returns NAME?