How to use the DEC2HEX function
The DEC2HEX function converts a decimal number to a hexadecimal number.
Formula in cell D3:
Excel Function Syntax
DEC2HEX(number, [places])
Arguments
| number | Required. The decimal integer you want to convert. |
| [places] | Optional. The number of characters to use. If not entered the function uses the number of characters needed to complete the task. This argument allows you to add leading 0s (zeros). |
Comments
The hexadecimal numeral system has a base of 16, 0-9 represents zero to nine and A,B,C,D,E and F represent values ten to fifteen.
For example, binary values ranging from 00000000 to 11111111 is represented as 00 to FF in hexadecimal which makes it easier to read.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Engineering'
The DEC2HEX function function is one of many functions in the 'Engineering' category.
How to use the BIN2DEC function
The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]
How to use the BIN2HEX function
The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]
How to use the BIN2OCT function
The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]
How to use the BITAND function
The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]
How to use the BITLSHIFT function
The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]
The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]
How to use the BITRSHIFT function
The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]
How to use the BITXOR function
The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]
How to use the COMPLEX function
The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]
How to use the CONVERT function
The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]
How to use the DEC2BIN function
The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]
How to use the DEC2HEX function
The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]
How to use the DEC2OCT function
The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]
The DELTA function evaluates whether two numerical values are equal. This function is also known as the Kronecker Delta function, read […]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form