hexadecmial to binary conversion

  • Thread starter platinum_eye200
  • Start date
P

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
 
B

Bernie Deitrick

Martin,

=HEX2BIN(A1,8)

You need to have the Analysis Toolpak install, IIRC.

HTH,
Bernie
MS Excel MVP
 
J

Jon S.

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

=HEX2BIN( Cell #) ???

Thanks,
Jon
 
B

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
 
Top