Remember Me?

#1
February 23rd 05, 09:39 PM
 tocuin hollisgroup com> Posts: n/a
Display Binary Leading Zeros

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?

Thomas

#2
February 23rd 05, 09:57 PM
 Carole O Posts: n/a

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?

Thomas

#3
February 24th 05, 01:12 AM
 Ron Rosenfeld Posts: n/a

On Wed, 23 Feb 2005 13:39:11 -0800, tocuin hollisgroup com <tquinn<atdot
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?

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post BigBrook Excel Discussion (Misc queries) 5 December 11th 08 08:00 PM Shadyhosta New Users to Excel 5 July 27th 05 04:37 PM JC Excel Discussion (Misc queries) 9 February 1st 05 02:33 PM marianthelibrarian Excel Discussion (Misc queries) 1 January 25th 05 02:08 PM World Referee and accountant Excel Discussion (Misc queries) 2 January 3rd 05 04:18 PM

All times are GMT +1. The time now is 01:02 PM.

The comments are property of their posters.

"It's about Microsoft Excel"