From ZCubes Wiki
Jump to navigation Jump to search


  • 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.



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 displays #NUM! error message.
  • 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.


HEX Input Octal Output
HEX2OCT("44F",5) 02117
HEX2OCT("17") 0000000027
HEX2OCT("D1C",-3) #NUM!
HEX2OCT("FFFFFFF") 1777777777

Related Videos


See Also