HEX2DEC function

Category: Engineering
Introduced: Excel 2003

Summary

Converts a hexadecimal number to decimal

Syntax

HEX2DEC(number) The HEX2DEC function syntax has the following arguments:
• Number Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Example

=HEX2DEC("A5")
=HEX2DEC("FFFFFFFF5B")
=HEX2DEC("3DA408B9")

Microsoft Support Page

https://support.microsoft.com/en-us/office/hex2dec-function-8c8c3155-9f37-45a5-a3ee-ee5379ef106e

Back to Functions