Where are the engineering functions?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Belov - 22 Nov 2006 20:55 GMT

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

Reply to this Message

Niek Otten - 22 Nov 2006 21:30 GMT

From Excel HELP:

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
[quoted text clipped - 11 lines]
|
| Charles "Chas" Belov

Reply to this Message

Gord Dibben - 22 Nov 2006 22:00 GMT

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 Tools>Add-ins.

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

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 11 lines]
>
>Charles "Chas" Belov

Reply to this Message