If you went to Help and looked for HEX2DEC you would see it is a Function from
the Analysis ToolPak which must be loaded through ToolsAdd-ins.

Now the #NAME? will go away as Help pointed out.


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 12:55:40 -0800, Charles Belov
wrote:

Excel 2003 help tells me I can use HEX2DEC to convert hexadecimal
numbers to decimal, but when I try to use it in a formula

=HEX2DEC(A2)

Excel changes it to read

=hex2dec(A2)

and displays #NAME? in the spreadsheet.

If I click on fX and select All, HEX2DEC does not appear in the list,
nor does any other of the engineering functions. How do I get them?

Charles "Chas" Belov