HEX2DEC(number)

Returns the number converted from hexadecimal to decimal.

numberThe hexadecimal number you want to convert.

Remarks

* If "number" contains more than 10 characters (40 bits), then #NUM is returned.
* If "number" is not a valid hexadecimal number, then #NUM! is returned.
* You can use the HEX2BIN function to convert a number from hexadecimal to binary.
* You can use the HEX2OCT function to convert a number from hexadecimal to octal.
* You can use the DEC2HEX function to convert a number from decimal to hexadecimal.
* In Excel 2007 the accuracy of this function was improved.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=HEX2DEC(1) = 1
2=HEX2DEC("1") = 1
3=HEX2DEC("01") = 1
4=HEX2DEC("001") = 1
5=HEX2DEC("2") = 2
6=HEX2DEC("E") = 14
7=HEX2DEC("FB") = 251
8=HEX2DEC("1FF") = 511
9=HEX2DEC("A5") = 165
10=HEX2DEC("FFFFFFFF5B") = -165
11=HEX2DEC("3D8B9") = 252089
12=HEX2DEC("FFFFFFFFF") = 68719476735
13=HEX2DEC("FFFFFFFFFF") = -1
14=HEX2DEC("FFFFFFFFFFF") = #NUM!
15=HEX2DEC("-200") = #NUM!
16=HEX2DEC("HIJKLMN") = #NUM!
17=HEX2DEC("some text") = #NUM!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top