DEC2HEX(number [,places])

Returns the number converted from decimal to hexadecimal.

numberThe decimal integer you want to convert.
places(Optional) The number of characters to use.

* If any of the arguments are not numeric, then #VALUE! is returned.
* If "number" < -549,755,813,888, then #NUM! is returned.
* If "number" > 549,755,813,887, then #NUM! is returned.
* If "number" < 0, "places" is ignored and a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit is returned. The remaining 39 bits are magnitude bits.
* If "number" < 0, then two's-complement notation is used to represent the number.
* If "places" is not an integer, it is truncated.
* If "places" < 0, then #NUM! is returned.
* If "places" is left blank, then the minimum number of characters necessary is used.
* The "places" is useful for padding the return value with leading 0s.
* If "places" is less than the number of characters needed, then #NUM! error value.
* You can use the DEC2BIN function to return a number converted from decimal to binary.
* You can use the DEC2OCT function to return a number converted from decimal to octal.
* You can use the HEX2DEC function to return a number converted from hexadecimal to decimal.
* For the Microsoft documentation refer to
* For the Google documentation refer to

1=DEC2HEX(100, 4) = 0064
3=DEC2HEX(100.6, 4) = 0064
4=DEC2HEX(100, -4) = #NUM!
5=DEC2HEX("some text", 4) = #VALUE!
6=DEC2HEX(6, "some text") = #VALUE!

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top