How to use the DEC2HEX function
Author: Oscar Cronquist Article last updated on May 11, 2022
The DEC2HEX function converts a decimal number to a hexadecimal number.
Formula in cell D3:
=DEC2HEX(B3,C3)
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.
Functions in 'Engineering' category
The DEC2HEX function function is one of many functions in the 'Engineering' category.
Converts a binary number to the decimal number system.
Converts a binary number to hexadecimal.
Converts a binary number to octal.
Calculates a bitwise 'AND' of two numbers.
Calculates a number whose binary representation is shifted left by a specified number of bits.
Performs a bitwise 'OR' of two numbers.
Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.
Returns a complex number based on a real and imaginary number.
Converts a number from one measurement system to another.
Converts a decimal number to a binary number.
Converts a decimal number to a hexadecimal number.
Converts a decimal number to an octal number.
Evaluates whether two numerical values are equal.
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