Excel Function : OCT2HEX

Download now!

Excel Function : OCT2HEX

Category

Engineering

Description

Converts an octal number to hexadecimal

Microsoft Excel Reference Page

https://support.office.com/en-us/article/OCT2HEX-function-912175b4-d497-41b4-a029-221f051b858f

Syntax and Description of the OCT2HEX Excel Function

I need to convert a numeric value to its hexadecimal representation in excel. I have tried oct2hex(value) but it does not work. A: Try this: =DEC2HEX(OCT2DEC(A1)) You might have to reverse the order of the parameters in the DEC2HEX() function, depending on your version of Excel.

About OCT2HEX Excel Function

The OCT2HEX function converts an octal number to a hexadecimal number.