[Rob Hood]

need a formula written, have been searching through the MS-help and can't seem to find a way to write the formula I want. I need a formula that shows the next number in column A when I enter data in column B.

For instance, if A2 says "1," then when I click on B3, I want A3 to show "2." I also need the number to show in five digits, e.g., 00001, 00002, etc.

Where's the enguhneers out there??? (IMG:http://www.frrax.com/rrforum/style_emoticons/default/smile.gif)

Rob

[Rob Hood]

pretty much banging my head like that emoticon...(IMG:http://www.frrax.com/rrforum/style_emoticons/default/wink.gif)

I was trying to make a "simple" sheet to log text data in a column format, but needed (wanted?) a column that assigned a number each time I inserted data in the other column.

So far, your counting method works for what I need in a basic format, and I've already gone ahead and built the page. However, I would like to be able to get that second function working. This is kinda like entering data for a job request, and when you enter that data, a job number gets assigned. It's just that my format requires the number column be first in a left-to-right format. (Not really "my" format either, just another Navy thing...)