HEX2OCT
Formulas / HEX2OCTConvert a hexadecimal number to octal.
HEX2OCT(number,base)
- number - required hexadecimal number
- places - [OPTIONAL] cannot be more than 10 characters
Examples
=HEX2OCT("F", 3) converts hexadecimal F to octal with 3 characters. This example is using the HEX2OCT function to convert the hexadecimal value of "F" to an octal with 3 characters. The result of this example is "017".
=HEX2OCT("3B4E") converts hexadecimal 3B4E to octal. This example is using the HEX2OCT function to convert the hexadecimal value of "3B4E" to an octal. The result of this example is "35364".
=HEX2OCT("FFFFFFFF00") converts hexadecimal FFFFFFFF00 to octal. This example is using the HEX2OCT function to convert the hexadecimal value of "FFFFFFFF00" to an octal. The result of this example is "37777777000".
Summary
The HEX2OCT function is used to convert a hexadecimal number to its equivalent octal notation. The number argument is required, while the places argument is optional. The number argument is the hexadecimal number to convert, and the places argument is the number of characters to use.
- The HEX2OCT function converts a hexadecimal (base 16) number to an octal (base 8) number.
- The HEX2OCT function pads the resulting octal number with zeros, if necessary, to produce the desired number of digits.
Need help with Formulas?
Frequently Asked Questions
What is the HEX2OCT function?
What is the required argument for the HEX2OCT function?
Is there an optional argument for the HEX2OCT function?
What is the syntax for the HEX2OCT function?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.