Adding a number consecutively...

[imuceus]

Hi, i am new to excel and am wondering if there is a way to add a number to each of the cells in a column to go from 0 to 100,000 in 1000 increments. Hopefully that makes sense to you experts. Thanks for the help and hopefully i will here back asap... I have an assignment due

 

[Smitty]

Welcome to the Board!

How about: =A1+1000 copied down.

HTH,

Smitty

 

[pgc01]

Hi imuceus

Write 0 in A1.
Edit>Fill>Series, Series in:Columns, Type:Linear, Step: 1000, Stop:100000

Hope this helps
PGC

 

[imuceus]

Thanks!!

Thanks for the replys everyone, that worked perfect!