Making Lists of numbers
 

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.

Making Lists of numbers
 

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.

Making Lists of numbers
 

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.

Making Lists of numbers
 

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

Making Lists of numbers
 

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.

Making Lists of numbers
 

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.