Description
Converts a hexadecimal number to octal.
Syntax
HEX2OCT ( "number" )
| Parameter | Description |
|---|---|
| number | The hexadecimal number to convert. |
Remarks
Number must be greater than FFE0000000 and less than 1FFFFFFF.
If number is negative, HEX2OCT returns a 10-character octal number.
If number is not a valid hexadecimal number, HEX2OCT returns the #NUM! error value.
Number cannot contain more than 10 characters. 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.
Examples
HEX2OCT ( "F" ) returns 17
HEX2OCT ( "3B4E" ) returns 35516
HEX2OCT ( "FFFFFFFF00" ) returns 7777777400
See also