-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,372
- Office Version
- 365
- Platform
- Windows
Welcome to the MrExcel board!
Any chance you could tell us a bit more about what you have, where and what you are trying to achieve? So far you have given us almost nothing to go on.
Unless the following will do.
6 digit code: 569213
Any chance you could tell us a bit more about what you have, where and what you are trying to achieve? So far you have given us almost nothing to go on.
Unless the following will do.
6 digit code: 569213
Upvote
0
In A1 type "0", in A2 type "1"...select both A1 and A2...drag down until you get to 999,999.
You will have a list of ALL possible 6 digit combinations of digits 0-9. (add zeros to the left side of combinations that are less than 6 digits)
EDIT: Actually you could probably get away with a LOT less if you don't care about the order of the digits.
You will have a list of ALL possible 6 digit combinations of digits 0-9. (add zeros to the left side of combinations that are less than 6 digits)
EDIT: Actually you could probably get away with a LOT less if you don't care about the order of the digits.
Last edited:
Upvote
0
If this is to open a safe with a lost entry code, I'd just forget it...have it drilled/cracked/broken into and buy a new safe.
It would take upwards of 100 days to try all 1,000,000 combinations, without counting time to...ya know, SLEEP...EAT...SHOWER....WORK. 100+ days if you did NOTHING but enter a code every 10 seconds, 24 hours a day.
It would take upwards of 100 days to try all 1,000,000 combinations, without counting time to...ya know, SLEEP...EAT...SHOWER....WORK. 100+ days if you did NOTHING but enter a code every 10 seconds, 24 hours a day.
Upvote
0
