Align numbers to take up equal space

G

Guest

Use a fixed-pitch font such as Courier

-----Original Message-----
I am trying to align the numbers in an excel spreadsheet
so that a 1 takes up the same amount of space as a 0. When
I align my numbers now, each character takes up a
different amount of space. How to I get the characters to
line up no matter what the actual numbers are?
Example: 00234 would take up more space then 11111
because the actual numbers are wider in the first example.
So if I had 00234 in cell A1 and then put 11111 in cell
A2, in looking at the spreadsheet the numbers look as if
they are not lined up.
 
Top