DEC2HEX(number, places)

  • Where 'number' is the decimal integer to be converted and
  • 'places' is the number of characters to be used to display the output.

DEC2HEX() converts a decimal number to its hexadecimal equivalent.


DEC2HEX(number, places)

  • The 'number' can be up to 20 digits (i.e. in-between -99999999999999999999 and -99999999999999999999).
  • Output is a 40 bit number. The most significant bit is the sign bit and remaining bits are magnitude bits.
  • If 'number' is negative, Calci ignores the places and returns a 10 character (40 bit) hexadecimal number.
  • 'places' argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary.
  • 'places' is used for padding the output with leading '0's'.
  • A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers.

For Example,

DEC2HEX(50,5) returns 00032

DEC2HEX(4567890) returns 000045B352

DEC2HEX(35,3.3) returns 0023

  • Calci displays an error message, if the 'number' is an invalid decimal number.
  • If the 'number' is not an integer, Calci considers the integer part, and displays the output.
  • Calci ignores the 'places', if the output is more than mentioned 'places'.
  • Calci ignores the 'places', if the 'places' is non-numeric or negative.
  • If 'places' is not an integer, Calci truncates the 'places' value.


Function HEX Output
DEC2HEX(512) 0000000200
DEC2HEX(512,3) 200
DEC2HEX(2378,-4) 94A
DEC2HEX(7878.78) 0000001EC6

Related Videos


See Also