P platinum_eye200 Jul 2, 2004 #1 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
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 Jul 2, 2004 #2 Martin, =HEX2BIN(A1,8) You need to have the Analysis Toolpak install, IIRC. HTH, Bernie MS Excel MVP
J Jon S. Jul 9, 2004 #3 Do you know how to do the same thing but with a Cell # instead. =HEX2BIN( Cell #) ??? Thanks, Jon
B Bernie Deitrick Jul 9, 2004 #4 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
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
