Zeros

[Hank Missenheim_Jr]

How can I preserve leading zeros in a cell? I'm entering equipment serial
numbers in cells, but any leading zeros are not displayed. I do have the
Zero Values box checked in Options. Thanks in advance. -Hank

 

[Dave Peterson]

You can preformat the cell as Text (format|cells|Number tab|Text)

or you can start the entry with an apostrophe: '001234

or you could give the cell a custom format that will show as many digits as you
want:
Format|cells|number tab|custom category
00000
(I used 5 digits)


====
Ps. Remove that check mark from the tools|Options setting. It will hide/show
cells that contain 0 (not numbers that contain 0 (like 101, 3232001230.)

 

[Beege]

How can I preserve leading zeros in a cell? I'm entering equipment serial
numbers in cells, but any leading zeros are not displayed. I do have the
Zero Values box checked in Options. Thanks in advance. -Hank

Hank,

Serial numbers are usually not calcualted, so format as text, or,
format/cells/custom "00000000" where the number of zeroes is the length of
your serials. If your serials vary in length, text is the best way. Or you
can precede the number entererd with a single apostrophe which will disapear
when you leave the cell.