How could I make a simple program in excel that I can print off serial number and voucher numbers?

How could I make a simple program in excel that I can print off serial number and voucher numbers? I am trying to Input a 9 digit serial code to get an output a voucher number (to a file) I.E Take the 9 digit serial number (123456789) 2) Reverse the digits (987654321) 3) Break into 3 groups of 3... show more How could I make a simple program in excel that I can print off serial number and voucher numbers?

I am trying to Input a 9 digit serial code to get an output a voucher number (to a file)

I.E
Take the 9 digit serial number (123456789)
2) Reverse the digits (987654321)
3) Break into 3 groups of 3 (987-654-321)
4) Add the 3 digits , to get a two digit sum between 0 and 27. (24-15-07)
5) Put the first digit at the start of the group and the last digit at the end (29874-16545-03217)
6) We now have 3 groups of 5 digits
7) Finally generate a final 5digit code

Please Help!!
1 answer 1