excel numbers

[slbut]

How do I get zero's to remain in front of another number in the cell?
ex: 001
002
003

 

[lenze]

Two ways:

You can format your cells as text and enter the zeros, or

You can choose Format>Cells. Select the custom format option. In the Type box, enter

000

This will display zeros before any 1 or 2 digit number entered
This message was edited by lenze on 2002-08-28 09:30

 

[joebars]

Just format the cell and create a custom format in the form 000.