Missing function in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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

Numerals conversion 2
Convert Decimal fractions to binary and vice versa 1
How can i convert an ASCII character to decimal/hex in Excel? 1
Conversion of Dec numbers to Bin, Oct and Hex and visa versa 2
Playing Sound Files in IE7 1
Convert numerals 11
the decimals extends after the sum function 2
Decimal to Time Format. 5

Back
Top