Description
Converts a hexadecimal number to decimal.
Syntax
HEX2DEC ( number )
| Parameter | Description |
|---|---|
| number | The hexadecimal number to convert. |
Remarks
If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.
Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Note: HEX2DEC may return unexpected results for input greater than 7FFF.
Examples
HEX2DEC ( "A5" ) returns 165
HEX2DEC ( "7FFFF" ) returns 32767
HEX2DEC ( "3DA408B9" ) returns 1034160313
See also