Zeros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hank Missenheim_Jr - 19 Oct 2006 14:06 GMT

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

Signature

Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Dave Peterson - 19 Oct 2006 14:11 GMT

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.)

> 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
>
> --
> Posted via a free Usenet account from http://www.teranews.com

Signature

Dave Peterson

Reply to this Message

Beege - 19 Oct 2006 14:14 GMT

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.

Reply to this Message