Try this:
=LEFT(A1,SEARCH("/",A1)-1)+1&"/"&TEXT(RIGHT(A1,LEN(A1)-SEARCH("/",A1))+1,"000000")

HTH
--
AP

"Mel" a écrit dans le message de news:
...
I have a two part number for tracking delivery notes, separated by a slash
and each number increasing sequentially eg 8987/010942, 8988/010943 etc.
How
can I do this automatically? Also Invoice Numbers eg ms/0988/06,
ms/0989/06
etc.

Thanks.