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?
|