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