Hi friends,
I need to create 4-digit sequence numners from 0001 to ZZZZ. It sould be
0001
0002
0003
....
9999
A000
A001
A002
....
A999
B000
B001
B002
....
Z999
AA00
AA01
AA02
....
AA99
AB00
AB01
....
AZ99
AAA1
....
ZZZZ
I have referred many threads and other forums, AskTom, Tkyte, etc. But I haven't got the answer. Most of the answers are Base 36. But my requirement is decimal based.
If the input is "1" then the output should be "0001"; input "999", output "0999"; input "9999", output "9999"; input "10000", output "A000"; input 10001, output "A0001"; and so on.
Thanks in advance.