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

hi,
enter your first number where you want it then high light the column you
want it in. click editfillseries. 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

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

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

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