Making Lists of numbers

N

nebula

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

Mike H

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
 
N

Niek Otten

=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


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

T. Valko

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 Edit>Fill>Series
Stop value: 3000
OK

With the range still selected
Goto the menu Format>Cells>Number tab>Custom
Type: 0000
OK
 
G

Gord Dibben

In A1 enter '0001

In A2 enter '0002

Note the leading apostrophe.

Type A1:A3000 in NameBox and Hit ENTER.

Edit>Fill>Series>Autofill


Gord Dibben MS Excel MVP
 
Top