Zeros??? Help!

  • Thread starter Thread starter cherokeeiris
  • Start date Start date
C

cherokeeiris

I am putting in numbers to arrange numerically. Some of my number
start with 0. However, when I enter it this way, the 0 disappears.
need it to remain. I tried the different formatting of the cell, etc
with no luck. Is there a way to do this? If so, how? Or am
S.O.L.?????

I'd sure appreciate any help on this!
Thanks
 
Give the cells a Custom format; something like 000000.00 or 00000 depending
on number of pre and post decimal digits.

best wishes
 
You have two options:
1. Use Text formatting, or
2. Use a (Custom) fixed length numeric formatting

In the first case, you won't be able to perform any mathematical operations
on the cells, but that's fine for, say, phone numbers.
In the second case you can, but it will only work if the number of digits is
fixed. Assuming you need five digits altogether, format the whole column (or
range) as Custom 00000, and any number up to five digits will maintain the
leading zeroes.

HTH,
Nikos
 
Back
Top