HEX2OCT

Formulas / HEX2OCT
Convert 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.


Frequently Asked Questions

What is the HEX2OCT function?
The HEX2OCT function is a mathematical function that converts a hexadecimal number to octal format.
What is the required argument for the HEX2OCT function?
The number argument is required for the HEX2OCT function. This argument is the hexadecimal number to convert.
Is there an optional argument for the HEX2OCT function?
Yes, there is an optional argument for the HEX2OCT function. The places argument is optional and is the number of characters to use.
What is the syntax for the HEX2OCT function?
The syntax for the HEX2OCT function is: HEX2OCT(number, places).

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.