DEC2HEX Function (Functions in Excel)
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. |
0 comments:
Post a Comment