View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Hexadecimal to binary

Can someone point me to an online resource or explain how I can convert a
hexadecimal number into a binary number whilst also retaining the leading
zeros.
Some of the hex numbers are too large for the HEX2BIN function. I need the
leading zeros in the result so I can look at specific chunks bit values
using MID().

Tia