HEX2DEC Function

how to use dec2hex function in excel

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

HEX2DEC Function has a limit of nine times "f" decimal numbers
If you write more than ten times "F" characters it will return"-1"
If you write more than ten times"F" it will return #NUM error




Number: it is the number you want to convert into hexadecimal


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

=HEX2DEC(D4) which will convert the hexadecimal number into decimal

On the right side, if you write nine times "F" it will return "68719476735"
if you write ten times "F" it will return "-1"
If you write more then ten times "F" it will return #NUM error


To convert a Hexadecimal number into a Decimal number


Decimal number

No comments:

Post a Comment