dumb excel question

Reply #6

Sandy K — Wed, 07 Jul 2004 01:19:35 GMT

Unseen,Go to the bar on top, click on Format, then Cells.Then click on Custom..............now if you want 001, you would type in 000 for 3 places, if you wanted 01, you would type in just 00 for 2 places..........click Ok and you're good to go.

Reply #5

CalifDude — Tue, 06 Jul 2004 22:52:13 GMT

I agree with the text. That is what I do. I also have one field that I have as a number, but with 3 decimal places. Then the zero works fine, just looks funny: 123 = 0.123

Reply #4

Webmaster L — Tue, 06 Jul 2004 21:47:25 GMT

Unseen,I am with the concept of entering it as a text field.Format the cell or column as text and then you can enter000001002etc.Webmaster LeRoy

Reply #3

gilla — Tue, 06 Jul 2004 21:17:45 GMT

Hit '0 to start a number begining with zero...for updating a cell at a time....

Reply #2

libra — Tue, 06 Jul 2004 16:54:41 GMT

If you are putting them in one cell, then it would have to be formatted as text to get the 0's to stay. I would suggest putting each digit in it's own cell and format them as numbers with nothing after the decimal.Libra Dave

Reply #1

johnph77 — Tue, 06 Jul 2004 16:48:09 GMT

If it is just a matter of storage and not for future mathematical refernce, save 001 as a label. Suggestion - when entering labels of this sort format them to display to the right side of the cell.gljohn

dumb excel question

unseen — Tue, 06 Jul 2004 16:33:07 GMT

how do I store my numbers that begin with zero in Excel? For instance if I put in 001. it just shows as 1.