OCT2HEX Function in Excel – Convert Octal to Hexadecimal in Excel

OCT2HEX Function in Excel converts Octal number to Hexadecimal number.

Syntax of OCT2HEX Function in Excel (OCTAL TO HEXADECIMAL FUNCTION IN EXCEL):

OCT2HEX(number,[places])

Where

number – The octal number that is to be converted to Hexadecimal.
[places] – An optional argument that specifies how many digits needs to be returned.

Example of OCT2HEX Function in Excel (OCTAL TO HEXADECIMAL FUNCTION IN EXCEL):

Formula:

OCT2HEX Function in Excel 1

In row number 2, OCT2HEX Function takes up [places] argument as 8 which returns the 8 digits with 6 preceding Zeros i.e. 000000BE.

Result:

OCT2HEX Function in Excel 2

Note: #NUM! – Error occurs

If the supplied number contains more than 10 character.
If the resulting hexadecimal number exceeds more than 10 digits.
If the supplied [places] argument is less than 0 and greater than 10.