How to display numbers as 000, 001, etc.
 

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

How to display numbers as 000, 001, etc.
 

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

"J. Gutierrez" wrote:

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

How to display numbers as 000, 001, etc.
 

Hi

FormatCellsNumberCustom 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


J. Gutierrez wrote:
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