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 (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

Relevance
  • GC
    Lv 4
    1 decade ago
    Best Answer

    Use the LEFT, RIGHT and MID functions to convert the original number into text bits, and recombine. You can generally add text fields that look like numbers as if they were numbers, and vice versa.

Still have questions? Get your answers by asking now.