HEX2OCT Function in Excel – Convert Hexadecimal to Octal in Excel

HEX2OCT Function in Excel converts Hexadecimal number to Octal number.

Syntax of HEX2OCT Function in Excel (HEXADECIMAL TO OCTAL FUNCTION IN EXCEL):

HEX2OCT(number,[places])

Where

  • number – The Hexadecimal number that is to be converted to Octal.
  • [places] –  An optional argument that specifies how many digits needs to be returned.

 

Example of HEX2OCT Function in Excel (HEXADECIMAL TO OCTAL FUNCTION IN EXCEL):

Formula:

HEX2OCT Function in Excel 1

  • In row number 2, HEX2OCT Function takes up [places] argument as 8 which returns the 8 digits with 4 preceding Zeros i.e. 00005454.

Result:

HEX2OCT Function in Excel 2

 

Note: #NUM! – Error occurs

  • If the supplied number contains more than 10 character.
  • If the resulting octal number exceeds more than 10 digits.
  • If the supplied [places] argument is less than 0 and greater than 10.

previous-small HEX2OCT Function in Excel                                                                                                           next_small HEX2OCT Function in Excel