DEC2HEX Function in Excel – Convert Decimal to Hexadecimal

DEC2HEX Function in Excel converts Decimal number to Hexadecimal number.

Syntax of DEC2HEX Function in Excel (DECIMAL TO HEXADECIMAL FUNCTION IN EXCEL):

DEC2HEX(number,[places])

Where

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

 

Example of DEC2HEX Function in Excel (DECIMAL TO HEXADECIMAL FUNCTION IN EXCEL):

Formula:

DEC2HEX Function in Excel 1

  • In row number 2, DEC2HEX Function takes up [places] argument as 8 which returns the 8 digits with 7 preceding Zeros i.e. 0000000E.

Result:

DEC2HEX Function in Excel 2

Note: #NUM! – Error occurs

  • If the supplied number argument is greater than 511 or less than -512
  • If the supplied [places] argument is less than 0 and greater than 10.

previous DEC2HEX Function in Excel                                                                                                                next DEC2HEX Function in Excel