Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

HEX2DEC function: Description, Usage, Syntax, Examples and Explanation

by Leave a Comment

What is HEX2DEC function in Excel?

HEX2DEC function is one of Engineering functions in Microsoft Excel that converts a hexadecimal number to decimal.

Syntax of HEX2DEC function

HEX2DEC(number)

The HEX2DEC function syntax has the following arguments:

  • Number: 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.

HEX2DEC formula explanation

If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.

Example of HEX2DEC function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if  need be.

Formula Description Result
=HEX2DEC(“A5”) Converts hexadecimal A5 to decimal 165
=HEX2DEC(“FFFFFFFF5B”) Converts hexadecimal FFFFFFFF5B to decimal -165
=HEX2DEC(“3DA408B9”) Converts hexadecimal 3DA408B9 to decimal 1.034E+09

Related Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *

A -Z Excel Functions and Formulas Example

3D SUMIF

ABS function

ACCRINT function

ACCRINTM function

ACOS function

ACOSH function

ACOT function

ACOTH function

ADDRESS function

AGGREGATE function

AMORDEGRC function

AMORLINC function

Analysis ToolPak

AND function

ARABIC function

Area Chart

AREAS function

ASC function

ASIN function

ASINH function

ATAN function

ATAN2 function

AVEDEV function

AVERAGE function

AVERAGEA function

AVERAGEIF function

AVERAGEIFS function

BAHTTEXT function

Bar Chart

BASE function

BESSELI function

BESSELJ function

BESSELK function

BESSELY function

BETA.DIST function

BETA.INV function

BIN2DEC function

BIN2HEX function

BIN2OCT function

BINOM.DIST function

BINOM.DIST.RANGE function

BINOM.INV function

BITAND function

BITLSHIFT function

BITOR function

BITRSHIFT function

BITXOR function

CAGR

CEILING function

CEILING.MATH function

CEILING.PRECISE function

CELL function

Cell Ranges & References

CHAR function

CHISQ.DIST function

CHISQ.DIST.RT function

CHISQ.INV function

CHISQ.INV.RT function

CHISQ.TEST function

CHOOSE function

CLEAN function

Clustered Column

CODE function

Column Chart

COLUMN function

COLUMNS function

COMBIN function

COMBINA function

Combo Chart

COMPLEX function

Compound Annual Growth Rate

CONCAT function

CONCATENATE function

Conditional Formatting

CONFIDENCE.NORM function

CONFIDENCE.T function

Conversion

CONVERT function

CORREL function

COS function

COSH function

COT function

COTH function

COUNT function

COUNTA function

COUNTBLANK function

COUNTIF function

COUNTIFS function

COUPDAYBS function

COUPDAYS function

COUPDAYSNC function

COUPNCD function

COUPNUM function

COUPPCD function

COVARIANCE.P function

COVARIANCE.S function

CSC function

CSCH function

CUBEKPIMEMBER function

CUBEMEMBER function

CUBEMEMBERPROPERTY function

CUBERANKEDMEMBER function

CUBESET function

CUBESETCOUNT function

CUBEVALUE function

CUMIPMT function

CUMPRINC function

Custom Number Format

Data Table

DATE function

DATEDIF function

DATEVALUE function

DAVERAGE function

DAY function

DAYS function

DAYS360 function

DB function

DBCS function

DCOUNT function

DCOUNTA function

DDB function

DEC2BIN function

DEC2HEX function

DEC2OCT function

DECIMAL function

DEGREES function

DELTA function

DEVSQ function

DGET function

DISC function

DMAX function

DMIN function

DOLLAR function

DOLLARDE function

DOLLARFR function

DPRODUCT function

DSTDEV function

DSTDEVP function

DSUM function

DURATION function

DVAR function

DVARP function

EDATE function

EFFECT function

ENCODEURL function

EOMONTH function

ERF function

ERFC function

ERFC.PRECISE function

ERROR.TYPE function

Errors

EVEN function

EXACT function

Excel Controls

EXP function

EXPON.DIST function

F.DIST function

F.DIST.RT function

F.INV function

F.TEST function

FACT function

FACTDOUBLE function

FALSE function

FILTERXML function

Find & Select

FIND function

FINDB function

FISHER function

FISHERINV function

FIXED function

FLOOR function

FLOOR.MATH function

FLOOR.PRECISE function

FORECAST function

Format Cell

Formulas and Functions

FORMULATEXT function

FREQUENCY function

Future value

FV function

FVSCHEDULE function

GAMMA function

GAMMA.DIST function

GAMMA.INV function

GAMMALN function

GAMMALN.PRECISE function

Gantt Chart

Gauge Chart

GAUSS function

GCD function

GEOMEAN function

GESTEP function

GETPIVOTDATA function

GROWTH function

HARMEAN function

HEX2BIN function

HEX2DEC function

HEX2OCT function

Histogram Chart

HLOOKUP function

HOUR function

HYPERLINK function

HYPGEOM.DIST function

IF function

IFERROR function

IFNA function

IFS function

IMABS function

IMAGINARY function

IMARGUMENT function

IMCONJUGATE function

IMCOS function

IMCOSH function

IMCOT function

IMCSC function

IMCSCH function

IMDIV function

IMEXP function

IMLN function

IMLOG10 function

IMLOG2 function

IMPOWER function

IMPRODUCT function

IMREAL function

IMSECH function

IMSIN function

IMSINH function

IMSQRT function

IMSUB function

IMSUM function

IMTAN function

INDEX function

INDIRECT function

INFO function

INT function

INTERCEPT function

Internet

INTRATE function

IPMT function

IRR function

IS function

ISBLANK function

ISERR function

ISERROR function

ISEVEN function

ISFORMULA function

ISLOGICAL function

ISNA function

ISNONTEXT function

ISNUMBER function

ISO.CEILING function

ISODD function

ISOWEEKNUM function

ISPMT function

ISREF function

ISTEXT function

KURT function

LARGE function

LCM function

LEFT function

LEFTB function

LEN function

LENB function

Line Chart

LINEST function

Links

LN function

LOG function

LOG10 function

LOGEST function

LOGNORM.DIST function

LOGNORM.INV function

LOOKUP function

LOWER function

Macro

MATCH function

MAX function

MAXA function

MAXIFS function

MDETERM function

MDURATION function

MEDIAN function

MID function

MIDB function

MIN function

MINA function

MINIFS function

MINUTE function

MINVERSE function

MIRR function

MMULT function

MOD function

MODE function

MODE.MULT function

MODE.SNGL function

MONTH function

MROUND function

MULTINOMIAL function

MUNIT function

N function

NA function

NEGBINOM.DIST function

Nested IF

Net Present Value

NETWORKDAYS function

NETWORKDAYS.INTL function

NOMINAL function

NORM.DIST function

NORM.INV function

NORM.S.DIST function

NORM.S.INV function

NOT function

NOW function

NPER function

NPV function

NUMBERVALUE function

OCT2BIN function

OCT2DEC function

OCT2HEX function

ODD function

ODDFPRICE function

ODDFYIELD function

ODDLPRICE function

ODDLYIELD function

OFFSET function

Operator Precedence

OR function

Pareto Chart

PDURATION function

PEARSON function

Percentage

PERCENTILE function

PERCENTILE.EXC function

PERCENTILE.INC function

PERCENTRANK.EXC function

PERCENTRANK.INC function

PERMUT function

PERMUTATIONA function

PHI function

PHONETIC function

PI function

Pie Chart

Pivot

PMT function

POISSON.DIST function

POWER function

PPMT function

Present value

PRICE function

PRICEDISC function

PRICEMAT function

Print

PROB function

Probability

PRODUCT function

PROPER function

Protect

PV function

QUARTILE function

QUARTILE.EXC function

QUARTILE.INC function

QUOTIENT function

RADIANS function

RAND function

RANDBETWEEN function

Random

RANK function

RANK.AVG function

RANK.EQ function

RATE function

RECEIVED function

REPLACE function

REPLACEB function

REPT function

Ribbon

RIGHT function

RIGHTB function

ROMAN function

ROUND function

ROUNDDOWN function

ROUNDUP function

ROW function

ROWS function

RRI function

RSQ function

Scatter Chart

SEARCH function

SEARCHB function

SEC function

SECH function

SECOND function

SEQUENCE function

SERIESSUM function

Share

SHEET function

SHEETS function

Shortcuts

SIGN function

SIN function

SINH function

SKEW function

SKEW.P function

SLN function

SLOPE function

SMALL function

Solver

Sort and Filter

Sparklines

Split Text

SQRT function

SQRTPI function

STANDARDIZE function

STDEV function

STDEV.S function

STDEVA function

STDEVPA function

STEYX function

SUBSTITUTE function

SUBTOTAL

SUBTOTAL function

SUM function

SUMIF function

SUMIFS function

SUMPRODUCT function

SUMSQ function

SUMX2MY2 function

SUMX2PY2 function

SUMXMY2 function

SWITCH function

SYD function

T function

T.DIST function

T.DIST.2T function

T.DIST.RT function

T.INV function

T.INV.2T function

T.TEST function

Tables

TAN function

TANH function

TBILLEQ function

TBILLPRICE function

TBILLYIELD function

Templates

TEXT function

TEXTJOIN function

Thermometer Chart

TIME function

TIMEVALUE function

TODAY function

TRANSPOSE function

TREND function

Trendline

TRIM function

TRIMMEAN function

TRUE function

TRUNC function

TYPE function

UNICHAR function

UNICODE function

Unix Time Stamp

UPPER function

VALUE function

VAR.P function

VAR.S function

VARA function

VARPA function

VDB function

View Tab

VLOOKUP function

WEBSERVICE function

WEEKDAY function

WEEKDAY.INTL function

WEEKNUM function

WEIBULL.DIST function

What-If Analysis:

Whisker Plot

Workbook

WORKDAY function

WORKDAY.INTL function

Worksheets

XIRR function

XNPV function

XOR function

YEAR function

YEARFRAC function

YIELD function

YIELDDISC function

YIELDMAT function

Z.TEST function