Can I set up sequential numbering in a colum in excel

[Quitefriendly1]

I need to set up a colum with sequential numbers ie 1001, 1002, 1003 and so
on I need to do it on Excel but cant find how on the help, im using Office
2000. Can anyone help please

John Wilson

[FSt1]

hi,
enter your first number where you want it then high light the column you
want it in. click edit>fill>series. follow the instructions.

regards
FSt1

"Quitefriendly1" wrote:

> I need to set up a colum with sequential numbers ie 1001, 1002, 1003 and so
> on I need to do it on Excel but cant find how on the help, im using Office
> 2000. Can anyone help please
>
> John Wilson

[Quitefriendly1]

Thank you, I did as you said but got only the number I entered tried several
times but ended with the same result

regards QF

"FSt1" wrote:

> hi,
> enter your first number where you want it then high light the column you
> want it in. click edit>fill>series. follow the instructions.
>
> regards
> FSt1
>
> "Quitefriendly1" wrote:
>
> > I need to set up a colum with sequential numbers ie 1001, 1002, 1003 and so
> > on I need to do it on Excel but cant find how on the help, im using Office
> > 2000. Can anyone help please
> >
> > John Wilson

[Gord Dibben]

Try this

Enter 1001 in A1

Right-click on the bottom right corner of A1 and drag down a ways until you
reach "so on"

Let go the mouse button and select "Fill Series" from the options.


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 15:50:02 -0700, Quitefriendly1
<Quitefriendly1@discussions.microsoft.com> wrote:

>Thank you, I did as you said but got only the number I entered tried several
>times but ended with the same result
>
>regards QF
>
>"FSt1" wrote:
>
>> hi,
>> enter your first number where you want it then high light the column you
>> want it in. click edit>fill>series. follow the instructions.
>>
>> regards
>> FSt1
>>
>> "Quitefriendly1" wrote:
>>
>> > I need to set up a colum with sequential numbers ie 1001, 1002, 1003 and so
>> > on I need to do it on Excel but cant find how on the help, im using Office
>> > 2000. Can anyone help please
>> >
>> > John Wilson

[David Biddulph]

"Quitefriendly1" <Quitefriendly1@discussions.microsoft.com> wrote in message
news:BBD54E8C-2869-48FC-831E-48F545EDFCF0@microsoft.com...

> "FSt1" wrote:

>> "Quitefriendly1" wrote:
>>
>> > I need to set up a colum with sequential numbers ie 1001, 1002, 1003
>> > and so
>> > on I need to do it on Excel but cant find how on the help, im using
>> > Office
>> > 2000. Can anyone help please

>> enter your first number where you want it then high light the column you
>> want it in. click edit>fill>series. follow the instructions.

> Thank you, I did as you said but got only the number I entered tried
> several
> times but ended with the same result

What did you have as the "step value" in the Edit/ Fill Series dialogue box?

Are you sure you didn't do Edit/ Fill DOWN, rather than Edit/ Fill SERIES?
--
David Biddulph