Or in the first cell, type an apostrophe and the number, e.g.:
'000001
Then drag the fill handle down.
If you don't need to do calculations with the numbers, this is quick and
easy

Peo Sjoblom wrote:
You need to enter at least 2 numbers in 2 cells using that method, else it
will be 1s only. You can hold down ctrl while doing this or right click and
drag to get a series like 1,2,3 etc




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html