Good afternoon,

I have a problem (the latest) which I have not a clue where to start.

Scenario:

Four character suffix to a part number starting '0001', when it gets to '9999' it needs to start consuming alpha characters, so starts again at 'A001'.
Then when it gets to 'Z999' the next value needs to use 'AA01' and so on until the last possible value it can spit out is 'ZZZZ'.

Question:

How?

While ever it only uses numeric characters to start with it's not a problem, that I can do, how though do I get it to start using the alpha characters once these are all exhausted?

Thanks in advance,

Paul