Missing function in Excel

M

Marie-Eve

I want to use the function DECHEX() to convert decimal numbers to
hexadecimal, but the function isn't installed on my PC.

Can I get a fix for that?
 
J

John Bundy

Its actually DEC2HEX() and from ms help
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
 
D

David Biddulph

The function you want is DEC2HEX, and it's in the Analysis ToolPak. Look
under Tools/ Add-ins.
 
Top