I’ve gotten it to work by using this formula in Excel:
=“47000”&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&“4982”&RANDBETWEEN(0,9)
Copy and paste this into any cell in Excel and it will generate a code for you, however, the last number will need to be modified. If, for example, the code you get is this:
470004228749823
you will have to replace the last digit (3 in this case) with all digits 0 through 9 and only one of those combinations will be a valid code. It’s a bit of time intensive process but I have gotten it to work. I have found that several codes I’ve come up using this method have already been used so I have to start over with a new code.
To get Excel to calculate a new code for you click on the cell with your formula in it, hit F2 and enter on your keyboard. This will force a recalculation of the random number generator.
Would love to hear if someone knows how to determine which digit to use at the end without having to cycle through up to 10 codes.