Thank you mam, it is working. Thank you very much for your concern.


"Ken Johnson" wrote:

Rao Ratan Singh wrote:
Dear mam,
I tried this formula but it is returning #value. I want to enter serial
number in this column A by using formula. First Number I m entering in A6
001-2007 without formula and after using formula the serial number should
return in this manner 001-2007, 002-2007, 003-2007 and so on downwards.


Hi RRS,

I typed 001-2007 into A6 then this formula into A7...

=REPT("0",2-INT(LOG(LEFT(A6,3)+1))) &(LEFT(A6,3)+1) & "-2007"

In A7 it returned 002-2007.

I then filled the formula down and it returned...

003-2007 in A8
004-2007 in A9
etc, etc, etc.

The formula will only return #VALUE once it is filled down to A1005 and
beyond.
Its final non-error value being 999-2007 in A1004.

Is this what you are wanting?
If so, then I don't understand your original request, which showed a
formula dependent on column E and column B cells.

Ken Johnson (Mr, not Miss or Mrs. Not that it really matters.)