# DEC2HEX

### Definition of DEC2HEX

Converts a decimal number to signed hexadecimal format.

### Sample Usage

`DEC2HEX(100,8)`

`DEC2HEX(A2)`

### Syntax

`DEC2HEX(decimal_number, [significant_digits])`

• `decimal_number` - The decimal value to be converted to signed hexadecimal, provided as a string.

• For this function, this value has a maximum of 549755813887 if positive, and a minimum of -549755814888 if negative.

• If `decimal_number` is provided as a valid decimal number, it will automatically be converted to the appropriate string input. For example, `DEC2HEX(100)` and `DEC2HEX("100")` yield the same result: `64`.

• `significant_digits` - [ OPTIONAL ] - The number of significant digits to ensure in the result.

• If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches `significant_digits`.

• This value is ignored if `decimal_number` is negative.

### Notes

• If the number of digits required is greater than the specified `significant_digits`, the `#NUM!` error is returned.
• Ensure that any calculations using the result of `DEC2HEX` take into account that it is in hexadecimal. Results will be silently converted; thus if cell `A2` contains `100`, the hexadecimal equivalent of the decimal value `256`, and `B2` contains a formula such as `=A2+20`, the result will be `120`, which is incorrect in hexadecimal calculation.

`OCT2HEX`: Converts a signed octal number to signed hexadecimal format.

`OCT2DEC`: Converts a signed octal number to decimal format.

`OCT2BIN`: Converts a signed octal number to signed binary format.

`HEX2OCT`: Converts a signed hexadecimal number to signed octal format.

`HEX2DEC`: Converts a signed hexadecimal number to decimal format.

`HEX2BIN`: Converts a signed hexadecimal number to signed binary format.

`DEC2OCT`: Converts a decimal number to signed octal format.

`DEC2BIN`: Converts a decimal number to signed binary format.

`BIN2OCT`: Converts a signed binary number to signed octal format.

`BIN2HEX`: Converts a signed binary number to signed hexadecimal format.

`BIN2DEC`: Converts a signed binary number to decimal format.

### By adding the value you would like to calculate the DEC2HEX formula for, Excellentable will generate the outcome:

Error.

User does not have sufficient privileges to access this Content