from AAA001 to ZZZ999

[belgiumbruno]

In our company we need the following kind of stocknumbers

the first item should be AAA001, the next AAA002,...AAA999

and from AAA999 to AAB001and so on to ZZZ999

attached is an example how I solved this problem.

If anyone has better solutions, don't hesitate to explain

automatische_loten.zip

[BobWeaver]

You can also use this formula to convert a numeric serial number into an alphanumeric type:

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",1+ Mod(Int(SerialNo/676000),26), 1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",1+ Mod(Int(SerialNo/26000),26), 1) &

Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ",1+ Mod(Int(SerialNo/1000),26), 1) &

Middle("0123456789",1+ Mod(Int(SerialNo/100),10), 1) &

Middle("0123456789",1+ Mod(Int(SerialNo/10),10), 1) &

Middle("0123456789",1+ Mod(SerialNo,10), 1)

[djgogi]

This is what I've done some time ago.

Dj

Alfa.fp5.zip

[jasonwood]

This is what I've done some time ago.

HOLY CRAP that's cool... It could take me a lifetime to figure out how it works but that's another story.

Thanks!