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

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

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