DEC2HEX Function

You can convert decimal numbers into hexadecimal numbers
The hexadecimal numbers contain only 0 and F values


DEC2HEX Function has a limit of eleven times "9" decimal numbers
If you write more than eleven times "9" characters it will return #NUM error

Syntax

=DEC2HEX(number,[places])

Argument

Number: it is the number you want to convert into hexadecimal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the decimal number and convert it into hexadecimal numbers.
We have written a formula  

=DEC2HEX(D4,4) which will convert the decimal number into hexadecimal and show result till 4 characters. No character place is filled by 0

On the right side, if you write eleven times "9" it will return "174876E7FF"
If you write more then eleven times "9" it will return #NUM error

Usage

To convert a Decimal number into a Hexadecimal number

Returns

Hexadecimal number