DEC2HEX Function

how to usde dec2hex function in excel

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




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.


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


To convert a Decimal number into a Hexadecimal number


Hexadecimal number

No comments:

Post a Comment