View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Can I set up sequential numbering in a colum in excel

"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