HEX2DEC
Formulas / HEX2DECConvert a hexadecimal number to its decimal equivalent.
=HEX2DEC(number)
- number - the hexadecimal number to convert; the number cannot exceed 10 characters
Examples
=HEX2DEC("A5")The HEX2DEC function can be used to convert a hexadecimal number to its decimal equivalent. For example, the hexadecimal number A5 can be converted to its decimal equivalent using the formula, resulting in a value of 165.
=HEX2DEC("FFFFFFFF5B")The HEX2DEC function can also be used to convert a string of hexadecimal numbers to a decimal value. For example, the hexadecimal string FFFFFFFF5B can be converted to its decimal equivalent using the formula, resulting in a value of 42949673595.
=HEX2DEC("3DA408B9")The HEX2DEC function can also be used to convert a longer string of hexadecimal numbers to a decimal value. For example, the hexadecimal string 3DA408B9 can be converted to its decimal equivalent using the formula , resulting in a value of 1034580441.
Summary
HEX2DEC is a function that can quickly convert a hexadecimal number to its decimal equivalent. It requires a valid hexadecimal number as an argument and cannot contain more than 10 characters.
- HEX2DEC is a Sourcetable function used to convert hexadecimal numbers to decimal numbers; this is useful when dealing with large numbers.
- The function is entered in the form of: HEX2DEC(hexadecimal number).
- Hexadecimal numbers are base 16, meaning they have 16 possible values for each digit, in contrast to decimal numbers which are base 10 and have 10 possible values for each digit.
- The HEX2DEC function is useful when dealing with large numbers that would be difficult and time consuming to convert manually.
Frequently Asked Questions
What is the HEX2DEC function?
What is the number argument?
What is the maximum character length of the number argument?
What additional information do I need to provide when using the HEX2DEC function?
