View Single Post
  #2   Report Post  
Carole O
 
Posts: n/a
Default

If this is just a cheat sheet - with no computation involved, try putting a '
in front of the zeros ('0000). The ' won't show in the cell or when you
print it out.

HTH,

Carole O

"tocuin" wrote:

All,

Forgive me if I'm just obtuse, but I can't seem to get Excel to display the
leading zeros of binary numbers. (I'm just doing up an ASC/DEC/HEX/BIN cheat
sheet.)

Formatting the cells as "Custom :: 00000000" doesn't work.

Any ideas as to how I do it?

Thanks in advance!

Thomas