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*

## No comments:

## Post a Comment