belgiumbruno Posted December 7, 2002 Share Posted December 7, 2002 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted December 8, 2002 Share Posted December 8, 2002 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) Link to comment Share on other sites More sharing options...
djgogi Posted December 9, 2002 Share Posted December 9, 2002 This is what I've done some time ago. Dj Alfa.fp5.zip Link to comment Share on other sites More sharing options...
jasonwood Posted December 11, 2002 Share Posted December 11, 2002 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! Link to comment Share on other sites More sharing options...
Recommended Posts