How to display numbers as 000, 001, etc.

[Guest]

Quick question for everyone...

How do I enter numbers with format 000, 001, 002, etc? I also need to be
able to "drag" the cells down to get me all the way to 999.

Any suggestions?

Thanks,

JG

 

[Guest]

Select "Format Cells" and choose a "Custom" format. Type in "000" for the
format.
That should be all you need to do.

 

[Roger Govier]

Hi

Format>Cells>Number>Custom 000

Put 0 in A1, 1 in A2, 2 in A3
Mark the block of 3 cells and use the fill handle (small black cross as you
hover over the bottom right of the cell) to fill down as far as you wish.

Regards

Roger Govier