Automatic sequence

[distraido]

Hello,
ia have a problem in colum C i have this value 18/00001 and if i selech the cell that has that value and drag dawn id does a sequence 18/00002/3/4 an so on.
I need a formula to do that, i tryed to do =c2+1 but i get an error and i am stuck on that.
And the value has to be in that format 18/00001.

[shg]

	C	D
2	18/00001	C2: Input
3	18/00002	C3: =LEFT(C2, 3) & TEXT(RIGHT(C2, 5) + 1, "00000")
4	18/00003
5	18/00004

[distraido]

worked fine thanks

[shg]

You're welcome.