2007-04-07 21:04:00 · 2 answers · asked by zezo 2 in Science & Mathematics ➔ Mathematics
If i have a range of numbers, 0-9, how can i figure out all the combinations of numbers I can make if there is 4 spots. Is there a program, like excel that can show me every single combination. I know that there are 10,000 possibilities, but I want to know what those combinations are. (For example, 0000,0100,0200,1111,2222,3333,... etc. but isn't there a program to do it for me.) Thanks
2007-04-07 21:04:38 · update #1
Format column A with a column width of 5 and leading 0's (4 digit). Enter 0 in A1 and 1 in A2. Select A1:A2 and use "fill down" to A9999.
2007-04-07 21:35:42 · answer #1 · answered by Helmut 7 · 0⤊ 0⤋
Just start with 0000 and keep adding 1 repeatedly. This will give you every possibility up to 9999.
2007-04-07 21:37:50 · answer #2 · answered by mathsmanretired 7 · 1⤊ 0⤋