Wonderful that works great. Now the long pass.... Can we do it with a 32
bit binary number?

Thanks.

"Tom Ogilvy" wrote:

=BIN2HEX(LEFT(B4,8))&BIN2HEX(RIGHT(B4,4))

--
regards,
Tom Ogilvy


"Chipmunk" wrote:

Yes. I can do it with 8 digits and some others but i need to convert a 12
digit binary number to hex. example: cell f11 has: 010101010101 what i
have is =bin2hex(F11) and it doesn work.

"Barb Reinhardt" wrote:

Have you tried function BIN2HEX?

"Chipmunk" wrote:

How to I convert a 32 bit binary number to hex?