HEX2DEC

Formulas / HEX2DEC
Convert 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?
The HEX2DEC function is a function that converts a hexadecimal number to a decimal number.
What is the number argument?
The number argument is a required parameter and is the hexadecimal number to convert.
What is the maximum character length of the number argument?
The number argument cannot contain more than 10 characters.
What additional information do I need to provide when using the HEX2DEC function?
No additional information is needed when using the HEX2DEC function, only the hexadecimal number to convert.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV