HEX2OCT(number,places)
- Where is a hexadecimal number to be converted and
- is the number of characters to be used to display the output.
HEX2OCT converts a hexadecimal number to its octal equivalent.
Description
HEX2OCT(number,places)
For Example,
HEX2OCT("A",4) returns 0012
HEX2OCT("FA",6) returns 000372
HEX2OCT("09") returns 0000000011
- must be a hexadecimal number. Hexadecimal number uses digits 0 to 9 and characters A to F. The number can also be entered in text format (e.g "1F").
- The most significant bit represents the 'sign' of the number. Negative numbers are represented using 2's complement notation.
- A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
- Calci returns an #ERROR message if is greater than 'FFFFFFF'.
- If is negative, Calci ignores the places and displays 10 digit octal output.
- If is not an integer, it is truncated.
- If are non-numeric, Calci returns an #ERROR message.
- If is negative, Calci ignores the places and uses the minimum number of digits required to display the octal output.
- If is omitted, Calci displays the 10 digit octal output by adding the leading zeros (if required).
- If is less than the digits required by the output, Calci ignores the places and uses the minimum number of digits required to display the octal output.
Examples
| HEX Input | Octal Output |
| HEX2OCT("44F",5) | 02117 |
| HEX2OCT("17") | 0000000027 |
| HEX2OCT("D1C",-3) | 6434 |
| HEX2OCT("FFFFFFF") | 1777777777 |