Mike

Type in the 3 numbers manually then select all 3 cells and drag down on the
fill handle of the lowest cell.

Mike

"woody" wrote:

I would like to know how i can do the following in excel?

101157
101158
101159 ect
Can this be done automatically when i drag the box down it will just do
101157 over and over please help