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.

Select the 3000 cells in the column bu selecting the top cell and dragging
down then
Format|Cells
Custom
enter a custom format of 0000 (That's 4 zeroes) and click OK

enter the top 2 numbers 1 & 2 and they should show as 0001, 0002
Select your range of cells again and
Edit|Fill|series
ensure linear is checked and click OK

Mike

"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.

Use a custom format 0000


--


Regards,


Peo Sjoblom


"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.

=ROW(), Format Custom as 0000
Copy down as far as you need
If you need it as text:
=TEXT(ROW(),"0000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"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.

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.

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.