G
Guest
Use a fixed-pitch font such as Courier
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?
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.
so that a 1 takes up the same amount of space as a 0. When-----Original Message-----
I am trying to align the numbers in an excel spreadsheet
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?
because the actual numbers are wider in the first example.Example: 00234 would take up more space then 11111
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.