[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]

ok, I'm getting there - thanks for all the input!! (IMG:http://www.frrax.com/rrforum/style_emoticons/default/smile.gif)

Mitch, once I figured out the "target cell" was not the SAME cell.... (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rant.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/banghead.gif) it all fell into place. Also got the numbers to display all five characters, thanks. Ihad looked at that earlier but wasn't able to make it display properly before.

Still working on making the number in Column A increase when I click on or enter data in Column B; I think that involves a function feature.

Rob