Jump to content
Server Maintenance This Week. ×

This topic is 7806 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.