When setting up user codes sometimes it's a pain having the client choose their own codes. They may use something easily discovered like the last 4 of their social or their phone extension, etc... Sometimes its just a matter of you don't want to take the time for 20 people to come up with their own code and Bob's out today and so forth.
To eliminate this, you can assign them your own randomly generated code using the Excel document attached. Just enter the users in column 1 and drag the formula from B2 as desired. It's not rocket science, but it works and I thought someone else might find it handy. This generates numbers from 9999 to 0. You can edit to your preference by playing with the first and last numbers inside the second set of parenthesis where the first number is the highest and second is the lowest.
Attachments
Files (1)
Original Post