How to display numbers as 000, 001, etc.

J

J. Gutierrez

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
 
E

Elkar

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

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
 
Top