I'm trying to print out all 1000 combos of 3 digits so I can open my briefcase lock. Can someone show me the excel formula to do so?
Thanks!
2007-12-31 04:31:34 · 6 answers · asked by Anonymous in Science & Mathematics ➔ Mathematics
Put 1 in cell A1
Hold shift and go down to cell 1000
Menu/Edit/Fill Series, enter
If you want it more compact for printing
put 1 in A1, then hold shift and use arrows or
mouse to select A1:J10
again, edit, Fill Series and enter
should fill the whole grid.
No formula involved.
If you need the reminder, highlight all the menu/format/cell/number and do leading zeros for 3 places.
2007-12-31 04:39:01 · answer #1 · answered by Mike1942f 7 · 0⤊ 1⤋
Open Excel. Format column A as Custom, format "0000" Put 0 in A1. Edit \ Fill > Series... Series in: Column Type: Linear Step Value: 1 Stop Value: 9999 That will give you every 4-digit combination from 0 to 9.
2016-04-02 04:28:43 · answer #2 · answered by ? 4 · 0⤊ 0⤋
Hammer
2007-12-31 05:21:20 · answer #3 · answered by mac 1 · 0⤊ 0⤋
You don't need Excel.
Test all numbers 000 to 999.
That is every combination.
There is no shorter list.
You probably used the combo before.
So take guesses and keep track of them.
Or, try a good hypnotist.
2007-12-31 05:05:52 · answer #4 · answered by ? 5 · 0⤊ 0⤋
do you only have digits 0 - 9 on the lock? if so, just count: 001, 002, 003, ..., 999. at 5 seconds per try, worst case it will take about an hour and a half.
I had a briefcase with locks like that. I retired 2 1/2 years ago, and have no idea where it is now.
Good luck.
2007-12-31 04:54:10 · answer #5 · answered by Philo 7 · 1⤊ 0⤋
Is this a joke?
-----------
Well, thanks for the thumbs down, but... Who in the world will need a print out of 1000 numbers to open a lock???.
What will you do? Test each one while crossing the wrong ones??
Why don't you try in order without the printout? 000, 001, 002, etc..
I just don't get it!!
2007-12-31 04:38:43 · answer #6 · answered by artie 4 · 1⤊ 1⤋