converts decimal number to hexadecimal · from excel · excel: verified match · sheets: verified match

signature

DEC2HEX(number, [places])

returns: text

argument	required
number	required
places	optional · defaults to 1

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

errors

error values observed from the engine — each with a call that produces it.

error	produced by
#NUM!	=DEC2HEX(64, 1)

related

• BESSELI returns modified Bessel function In(x)
• BESSELJ returns Bessel function Jn(x)
• BESSELK returns modified Bessel function Kn(x)
• BESSELY returns Bessel function Yn(x)
• BIN2DEC converts binary number to decimal
• BIN2HEX converts binary number to hexadecimal