Ron Rosenfeld wrote...
jay wrote...
I Had A Row Of Hexadecimal Numbers I Want To Convert it to Decimal So
I Used
The Following Formula in the colloun On Cell # b2 =HEX2DEC(A2) Wher
A2 Has
The Hexadecimal Number And THe error I Get is #NUM

Most likely, the number in A2 is not a valid hexadecimal number.

What, exactly, is the contents of A2?

In case either the hexadecimal number strings contain spaces or more
than 10 characters, try this (assumes unsigned)

=SUMPRODUCT(SEARCH(MID(RIGHT(REPT("0",32)&TRIM(A23 ),32),
ROW(INDIRECT("1:32")),1),"0123456789ABCDEF")-1,16^(32-ROW(INDIRECT("1:32"))))