If your numbers are in column A, maybe you could just put a bunch of formulas in
that column that depend on another column having data.

=if(b10="","",a9+1)

(in A10, and drag down.)

horseman wrote:

In my spreadsheet I have a cell called file number. Is their anyway that a
can get this cell to automatically put in the next number everytime I enter
new data, so that I do not have to type in the number it is excel 2000

--

Dave Peterson