HEX2OCT
Definition of HEX2OCT
Converts a signed hexadecimal number to signed octal format.
Sample Usage
HEX2OCT("f3",8)
HEX2OCT(A2)
Syntax
HEX2OCT(signed_hexadecimal_number, [significant_digits])
signed_hexadecimal_number
 The signed 40bit hexadecimal value to be converted to signed octal, provided as a string.The most significant bit of
signed_hexadecimal_number
is the sign bit; that is, negative numbers are represented in two's complement format.For this function, this value has a maximum of 1FFFFFFF if positive, and a minimum of FFE0000000 if negative.
If
signed_hexadecimal_number
is provided as a valid hexadecimal number, it will automatically be converted to the appropriate string input. For example,HEX2OCT(199)
andHEX2OCT("199")
yield the same result:631
.
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 leftpadded with zeros until the total number of digits reaches
significant_digits
.This value is ignored if the most significant bit of
signed_hexadecimal_number
is1
; that is, if the expressedsigned_hexadecimal_number
is greater than or equal to 8000000000.
Notes
As with any hexadecimal value, only the digits
09
and the lettersAF
are valid. Digits other than these will causeHEX2OCT
to return a#NUM!
error. Hexadecimal digits are not casesensitive;
af
andAF
are equivalent.
 Hexadecimal digits are not casesensitive;
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 HEX2OCT take into account that it is in octal. Results will be silently converted; thus if cell
A2
contains111
, the octal equivalent of hexadecimal49
, andB2
contains a formula such as=A2+9
, the result will be120
, which is incorrect in octal calculation.
See Also
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.
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.
DEC2HEX
: Converts a decimal number to signed hexadecimal 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.
In order to use the HEX2OCT formula, start with your edited Excellentable:
Then type in the HEX2OCT Formula in the area you would like to display the outcome:
By adding the values you would like to calculate the HEX2OCT formula for, Excellentable will generate the outcome:
A

B

C

D



1


2


3


4


5


6


7


8


9


10


11


12


13


14


15

E

F

G



1
