Hi Bob,

Thank you for your replay. I found my error but how to correct it.
In cell A1 I have 08 02 13
This has spaces which Excel detects as text.

In cell A2 I have =LEFT(A1,SEARCH(" ",A1,1))
The result is 08, again this is detected as text

In cell A3 I have =hex2bin(UPPER(A2),8) or =hex2bin(A2,8)
Both provide the #NUM error. Untill today I overlooked the fact that A2 was
not a number.

I have tried the Convert text to number as described in Help but I never get
the Convert option.

Again thanks for your help


"Bob Phillips" wrote:

It works fine on a cell with a formula as long as a valid result is
returned.

You might want to upshift text to help it though

=hex2bin(UPPER(D6),8)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Geo" wrote in message
...
I am trying to use =HEX2BIN(A2,8)

If cell A2 has data this will work

If cell A2 has a formula it will not work

Does anyone know of a workaround?

Thanks