From Excel HELP:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Charles Belov" wrote in message ...
| 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