DEC2HEX function

Converts a decimal number to hexadecimal.

Syntax

DEC2HEX(number,places)

Argument	Description	Remarks
number	The decimal integer you want to convert. If number is negative, places is ignored and this function returns a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.	If number < -549,755,813,888 or if number > 549,755,813,887, this function returns the #NUM! error value. If this argument is nonnumeric, this function returns the #VALUE! error value.
places	The number of characters to use. The places argument is useful for padding the return value with leading 0s (zeros).	If this argument is omitted, this function uses the minimum number of characters necessary. If this function requires more than places characters, it returns the #NUM! error value. If this argument is nonnumeric, this function returns the #VALUE! error value. If this argument is negative, this function returns the #NUM! error value. If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

A	B
Formula	Description (Result)
=DEC2HEX(100,4)	Converts decimal 100 to hexadecimal with 4 characters (0064)
=DEC2HEX(-54)	Converts decimal -54 to hexadecimal (FFFFFFFFCA)

See also
BIN2DEC function
HEX2DEC function
OCT2DEC function
List of all functions (by category)

Share your feedback about this topic

Rate this content: