HEX.TO.OCT

Converts a hexadecimal number to octal.

Syntax

=HEX.TO.OCT(Number, [Places])

Arguments

Name	Type	Description
Number	Number	The hexadecimal number to convert.
Places (optional)	Number	The number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return

Type	Description
Number or Error	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 not numeric or negative.

Examples

Formula	Result	Comment
=HEX.TO.OCT("F")	17	converts hexadecimal F to octal
=HEX.TO.OCT("F", 4)	0017	converts hexadecimal F to octal with 4 characters