Skip to main content
Version: Streamsheets 2.4

HEX2OCT

Converts a hexadecimal number to octal.

Syntax

=HEX2OCT(Number, [Places])

Arguments

NameDescription
NumberThe hexadecimal number to convert.
PlacesOptional. The number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return Value

The octal number or a #NUM! error if given number is not a valid hexadecimal number. The #VALUE! error is returned if specified places is nonnumeric or negative.

Example

FunctionResultComment
=HEX2OCT("F")17converts hexadecimal F to octal
=HEX2OCT("F", 4)0017converts hexadecimal F to octal with 4 characters