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.
