Dec2Hexa Formula
|
|
|
|
|
|
|
|
|
|
Decimal Number
|
Hexadecimal
|
|
|
|
|
|
|
0
|
0
|
=DEC2HEX(C4)
|
|
|
|
|
|
1
|
1
|
=DEC2HEX(C5)
|
|
|
|
|
|
2
|
2
|
=DEC2HEX(C6)
|
|
|
|
|
|
3
|
3
|
=DEC2HEX(C7)
|
|
|
|
|
|
25
|
19
|
=DEC2HEX(C8)
|
|
|
|
|
|
26
|
1A
|
=DEC2HEX(C9)
|
|
|
|
|
|
27
|
1B
|
=DEC2HEX(C10)
|
|
|
|
|
|
28
|
1C
|
=DEC2HEX(C11)
|
|
|
|
|
|
-1
|
FFFFFFFFFF
|
=DEC2HEX(C12)
|
|
|
|
|
|
-2
|
FFFFFFFFFE
|
=DEC2HEX(C13)
|
|
|
|
|
|
-3
|
FFFFFFFFFD
|
=DEC2HEX(C14)
|
|
|
|
|
|
-2
|
FFFFFFFFFE
|
=DEC2HEX(C15)
|
|
|
|
|
|
-1
|
FFFFFFFFFF
|
=DEC2HEX(C16)
|
|
|
|
|
|
549,755,813,887
|
7FFFFFFFFF
|
=DEC2HEX(C17)
|
|
|
|
|
|
-549,755,813,888
|
8000000000
|
=DEC2HEX(C18)
|
|
|
|
|
|
549,755,813,888
|
#NUM!
|
=DEC2HEX(C19)
|
|
|
|
|
|
-549,755,813,889
|
#NUM!
|
=DEC2HEX(C20)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Decimal
Number
|
Places To Pad
|
Hexadecimal
|
|
|
|
|
|
1
|
1
|
1
|
=DEC2HEX(C23,D23)
|
||
|
|
1
|
2
|
01
|
=DEC2HEX(C24,D24)
|
||
|
|
26
|
3
|
01A
|
=DEC2HEX(C25,D25)
|
||
|
|
26
|
9
|
00000001A
|
=DEC2HEX(C26,D26)
|
||
|
|
-26
|
1
|
FFFFFFFFE6
|
=DEC2HEX(C27,D27)
|
||
|
|
|
|
|
|
|
|
|
What Does It Do ?
|
|
|
|
|
||
|
This
function converts a decimal number to its hexadecimal equivalent.
|
|
|||||
|
It can
only cope with decimals ranging from -549,755,813,888 to 549,755,813,887.
|
||||||
|
The
result can be padded with leading 0 zeros, although this is ignored for
negatives.
|
||||||
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
=DEC2HEX(DecimalNumber,PlacesToPad)
|
|
|
|
|||
|
The
PlacesToPad is optional.
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
||
|
No
special formatting is needed.
|
|
|
|
|||