To fill A1:A3000 with the numbers 0001 to 3000:

Enter 1 in A1
Hit function key F5
Type A1:A3000
Hit Enter
Goto the menu EditFillSeries
Stop value: 3000
OK

With the range still selected
Goto the menu FormatCellsNumber tabCustom
Type: 0000
OK

--
Biff
Microsoft Excel MVP


"nebula" wrote in message
...
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.