Missing function in Excel

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
Numerals conversion 2
How can i convert an ASCII character to decimal/hex in Excel? 1
Convert numerals 11
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 2
Can I use HEX2DEC with cell references vs. numbers? 8
Playing Sound Files in IE7 1
Decimal to Time Format. 5

Top