[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

[RedHardSupra]

First part is either trivial or I'm not getting the question.
if you mean:

CODE

1      2
2      3

then B1=1 and B2=2 are just numbers, but where 2 is, you just put =B2+1

The second part you can most probably get through formatting, excel is good with that, click through all the numeric formats, it might just have what you need. if not, do whatever you need in normal numeric form, then you have another table of all this, but mangled into text, and 'padded' zeros.

In OpenOffice (excel contender from OpenSource side of things) you can just click on the cell, 'format cells' and type in number of 'leading zeros' and v'oile. I haven't used Excel in ages, but I assume they got something similar.

Hope this helps, if not, keep on posting, or catch me on AIM, bushmannt is the name.