hexadecmial to binary conversion

[platinum_eye200]

how do i convert a hexadecmial no. like 6D to 8 bit binary, is there
function, or do I have to delve in VB

thanks,

marti

 

[Bernie Deitrick]

Martin,

=HEX2BIN(A1,8)

You need to have the Analysis Toolpak install, IIRC.

HTH,
Bernie
MS Excel MVP

 

[Jon S.]

Do you know how to do the same thing but with a Cell #
instead.

=HEX2BIN( Cell #) ???

Thanks,
Jon

 

[Bernie Deitrick]

Jon,

In the example I provided:

=HEX2BIN(A1,8)

A1 is the cell address, not a Hex. To pass the Hex value A1, you would need
to use

=HEX2BIN("A1",8)

HTH,
Bernie
MS Excel MVP