Skip to main content
Version: Streamsheets 2.5

OCT2HEX

Converts an octal number to hexadecimal.

Syntax

=OCT2HEX(Number, [Places])

Arguments

NameDescription
NumberThe octal number to convert.
Places (optional)The number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return

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

Examples

FormulaResultComment
=OCT2HEX(100)
40converts octal 100 to hexadecimal
=OCT2HEX(100, 4)
0040converts octal 100 to hexadecimal with 4 characters