ID EN
#Engineering

HEX2OCT

Excel Functions

Converts a hexadecimal number to octal

Syntax

EXCEL
=HEX2OCT(number, [places])

Arguments

Parameter Description
number The hexadecimal number you want to convert to octal.
places [optional] Pads the resulting binary number with zeros up to the specified number of digits. If omitted returns the least number of characters required to represent the number.

Return Value

Octal number

Details

Excel interprets both octal and hexadecimal numbers using two's complement notation. Two's complement notation is a convention that computers use to represent negative numbers in binary.

See Also

OCT2HEX HEX2DEC HEX2BIN DECIMAL