Display Binary Leading Zeros

[Guest]

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

 

[Guest]

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

 

[Ron Rosenfeld]

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

How are you generating your binary numbers?

If you are using the ATP function, DEC2BIN, then you should use the optional
"places" argument: e.g. =DEC2BIN(A1,8)

Your custom format won't work as the output of DEC2BIN is a text string, and
not a number (even though it looks like one)

Is this sort of the output format you want?

=====================================
ASC BIN DEC HEX
1 00110001 49 31
2 00110010 50 32
3 00110011 51 33
4 00110100 52 34
5 00110101 53 35

A 01000001 65 41
B 01000010 66 42
C 01000011 67 43

a 01100001 97 61
b 01100010 98 62
c 01100011 99 63
====================================


--ron