- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: Serial number generator
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Serial number generator"
Collapse
-
It's not 5min if you don't want any value to be valid. I wrote one a while back with a few rules in and it was a bit of a pain. I couldn't find anything simple that already did this which surprised me.Originally posted by Sockpuppet View PostWhy not code one yourself. Doesn't look like more than 5 mins coding. How the serial works will mostly depend on how you want to put some checksums in there to stop it being cracked. Once you've worked that out the rest is easy.
Leave a comment:
-
Actually A1-D1 you need
=int(100000*rand())
Otherwise works ok.
40005-88863-01206-96417-66044
40005-42234-16137-76414-17631
40005-76773-38552-29731-96664
40005-16538-12253-66953-69267
40005-54940-53351-08973-37871
40005-46099-30337-30678-71262
40005-18516-88358-12862-57096
40005-42846-94455-42677-15131
40005-90739-15050-56630-41729
40005-46455-37635-35233-66349
40005-68477-26012-73211-89297
40005-63656-25269-36979-17348
40005-73675-84776-05998-79347
40005-72120-28980-29534-18443
40005-91312-54841-84312-77741
40005-89428-00814-65354-59513
40005-57312-89746-85147-92536
40005-94017-49069-48964-57595
It will change values when you open so for record cut n paste generated list as text.
Leave a comment:
-
Use Excel. Off top of head;
Put this in A1,B1,C1,D1:
=99999*rnd()+1
Then E1:
= "40005-" & text(A1,"00000") & "-" & text(B1,"00000") & "-" & text(C1,"00000") & "-" & text(D1,"00000")
Copy these to as many rows as needed. If that's not quite right, examples in help.
Leave a comment:
-
I'm not a coder.Originally posted by Sockpuppet View PostWhy not code one yourself. Doesn't look like more than 5 mins coding. How the serial works will mostly depend on how you want to put some checksums in there to stop it being cracked. Once you've worked that out the rest is easy.
Leave a comment:
-
Originally posted by Cliphead View PostI'm looking for an app that can generate serial numbers to a specific format something like;
40005-12345-54321-09876-34567
The first group of 5 numbers I choose via the app (this identifies the product - 40005), the rest being unique / randomly generated.
I would also like to be able to specify how many serials I want, 100, 50,000 etc.
Not having much luck searching on Google. Anybody know of such an app?
Why not code one yourself. Doesn't look like more than 5 mins coding. How the serial works will mostly depend on how you want to put some checksums in there to stop it being cracked. Once you've worked that out the rest is easy.
Leave a comment:
-
Serial number generator
I'm looking for an app that can generate serial numbers to a specific format something like;
40005-12345-54321-09876-34567
The first group of 5 numbers I choose via the app (this identifies the product - 40005), the rest being unique / randomly generated.
I would also like to be able to specify how many serials I want, 100, 50,000 etc.
Not having much luck searching on Google. Anybody know of such an app?Tags: None
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Crypto tax and contractors: What HMRC’s new cryptoasset research really means Today 04:03
- Crypto Tax and Contractors: What HMRC's New Cryptoasset Research Really Means Today 04:03
- Profit and loss accounts set for public filing at Companies House from 2028 — what it means for your contractor business Yesterday 03:38
- UK IT Contractors: How to land Forward Deployed Engineer roles beyond Palantir, Anthropic and OpenAI Jun 29 05:52
- The 3 highest-paying software contractor jobs right now, and what they actually pay Jun 25 03:52
- The beginning of the end for Boox ‘MSC’ contractors has begun. Check back in 2031 Jun 24 06:25
- Andy Burnham as prime minister ‘would cut both ways for self-employed contractors’ Jun 23 02:18
- The 3 highest-paying software contractor jobs right now, and what they actually pay Jun 22 15:52
- Taxman tells contractors that only four new tax avoidance schemes needed avoiding in Q2 Jun 22 05:47
- VAT compliance checks are changing — here’s what contractors need to know Jun 17 07:30


Leave a comment: