Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Engineering > HEX2DEC
 

HEX2DEC(number)

 
 Returns the number converted from hexadecimal to decimal.

 numberThe hexadecimal number you want to convert.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• 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.

     EXAMPLES
     
     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!
    		 
     Functions - H | Index - H | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top