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

Syntax


=DEC2HEX(number)

Argument

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

Behavior





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

Usage

To convert a Hexadecimal number into a Decimal number

Returns

Decimal number

No comments:

Post a Comment