In A1 enter '0001

In A2 enter '0002

Note the leading apostrophe.

Type A1:A3000 in NameBox and Hit ENTER.

EditFillSeriesAutofill


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 13:33:02 -0700, nebula
wrote:

Hello
I need to fill Column aye with the numbers 0001-3000
obviously it will make me very unhappy if i have to type each number in the
field.
is there any way that excel just fills in the rest of the values? (and
leaves the extra zeroes on the front?) thank you.