OCT2HEX
Formulas / OCT2HEXConvert an octal number to hexadecimal.
OCT2HEX(number, [places])
- number - required, the octal number to convert
- places - [OPTIONAL] the number of characters to use, useful for padding the return value with leading zeroes
Examples
=OCT2HEX(100, 4)The OCT2HEX function can be used to convert octal numbers to hexadecimal. In this example, the octal number 100 is converted to hexadecimal with a length of 4. The result of this formula is 64.
=OCT2HEX(7777777533)The OCT2HEX function can be used to convert large octal numbers to their hexadecimal equivalents. In this example, the octal number 7777777533 is converted to hexadecimal. The result of this formula is FFFFFF7A5.
Summary
OCT2HEX is a function that converts an octal number to hexadecimal form, returning a 10-character hexadecimal number if the number is negative.
- The OCT2HEX function converts an octal number to a 10-character hexadecimal number regardless of sign.
Frequently Asked Questions
What is the OCT2HEX function?
The OCT2HEX function is a Sourcetable function that is used to convert an octal number to a hexadecimal form.
What is the output of the OCT2HEX function?
The OCT2HEX function returns a 10-character hexadecimal number if the number is negative.
What happens if the number is not a valid octal number?
If the number is not a valid octal number, the OCT2HEX function will return the #NUM! error.
What are some tips for using the OCT2HEX function?
- Make sure that the number you are entering is a valid octal number.
- Remember that the output of the OCT2HEX function is a 10-character hexadecimal number if the number is negative.
- If the number is not a valid octal number, the OCT2HEX function will return the #NUM! error.
