Use Of Dec2Hex
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)
| |
##############
|
7FFFFFFFFF
|
=DEC2HEX(C17)
| |
##############
|
8000000000
|
=DEC2HEX(C18)
| |
##############
|
#NUM!
|
=DEC2HEX(C19)
| |
##############
|
#NUM!
|
=DEC2HEX(C20)
| |
Decimal Number
|
Places To Pad
|
Hexadecimal
| |
1
|
1
|
1
| |
1
|
2
|
01
| |
26
|
3
|
01A
| |
26
|
9
|
00000001A
| |
-26
|
1
|
FFFFFFFFE6
| |
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.
| |||
मेरी कहानियाँ Index प्रतिदिन सुविचार
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें