What is ;

  • Thread starter Thread starter NotMathWiz
  • Start date Start date
N

NotMathWiz

What is : 5 or 13 characters, or 10 or 26 characters using digits 0 - 9 and
letters A - F? Some say i should use the DEC2HEX formula, but i still don't
know how...
 
Hexadecimal is a numbering system using 16 as its base. The numbers in
hexadecimal are 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F, These correspond to the
numbers in the decimal system, base 10, of
0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15. In decimal when we add 1 to 9, we
get 10. In hexadecimal when we add 1 to F we get 10.
In other words in any numbering system, there is no one digit number that is
equal to the base. In binary, base 2, there is no number 2, just 0 and 1.
When we add 1 to 1 in binary, we get 10, 2 in decimal. You may use the
Dec2Hex function in Excel. If your decimal value, say 20 is in cell A1, in
cell B1 you could enter =DEC2HEX(A1) and B1 will say 14. 20 decimal is 14
hexadecimal.

Tyro
 
What is : 5 or 13 characters, or 10 or 26 characters using digits 0 - 9
and letters A - F? Some say i should use the DEC2HEX formula, but
i still don't know how...
Click to expand...

If the string of characters is composed of just 0-9 and A-F (or a-f),
you have a hexadecimal number (aka "hex" number). You would use
HEX2DEC, not DEC2HEX, to convert it.

However, HEX2DEC can handle up to only a 10-character hex number. So
HEX2DEC cannot be used easily to conver 13- and 26-character hex
numbers. There is a way to "shift" the result; but you cannot convert
more than a 13-character hex number without losing "precision". That
is, the converted value will no longer match the hex number if it was
14 characters or more.

Also, the HEX2DEC result is a signed number. If the 10-character
string starts with 8 or higher (A-F are higher than 9), you will get a
negative number as the result. That might not be what you intend.

Are you sure you should convert the hex number? In many contexts, the
hex number is an identifier of sorts, not intended to be treated as a
number. For example, a MAC address (which identifies network cards)
is a 12-character hex number. A new standard defines a 16-character
hex number called an EUI. It is currently use for some new network
types (e.g. Infiniband; also IPv6?). (But usually, the MAC and EUI
numbers are written with interstitial colons.)
 
Back
Top