Excel HEX2OCT function

Function              HEX2OCT

Description        Excel HEX2OCT function converts Hexadecimal number system to Octal number system.

Syntax                  HEX2OCT(number, [places])

Number               is the hexadecimal number and it should not be more than 10 characters. Negative numbers are returned with two’s complement method.

[places]               Optional. Which specifies the number of characters that you want the returned octal number to have. If omitted returns the least number of characters required to represent the number.

Example:

Usage Notes:

• If number is negative, HEX2OCT ignores places and returns a 10-character Octal number.
• FFE0000000 is the most negative number to be entered as argument, and 1FFFFFFF is the largest number.
• HEX2OCT returns the #NUM! error value when number is not a valid hexadecimal number.
• It returns the #NUM! error value when HEX2OCT requires more than places characters.
• It is truncated when places is not an integer.
• HEX2OCT returns the #VALUE! error value when places is nonnumeric.
• HEX2OCT returns the #NUM! error value when places is negative.