ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Missing function in Excel (https://www.excelbanter.com/excel-worksheet-functions/153435-missing-function-excel.html)

Marie-Eve

Missing function in Excel
 
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?

John Bundy

Missing function in Excel
 
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.


--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Marie-Eve" wrote:

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?


Sean Timmons

Missing function in Excel
 
The formula is DEC2HEX()

Tools - Add_Ins - Analysis ToolPak

"Marie-Eve" wrote:

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?


David Biddulph[_2_]

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

"Marie-Eve" wrote in message
...
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?





All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com