On Mon, 24 Jan 2005 17:37:02 -0800, jay wrote:

ear Bob.
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
THanks For Ur replay
jay

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

What, exactly, is the contents of A2?


--ron