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*

## No comments:

## Post a Comment