|Posted: July 13, 2007, 2:14 pm - IP Logged|
Not sure what you want.
If you just want a list of 10,000 Pick 4 combinations just enter 0000 in cell A1
Click cell A1
Right Click>Format Cells>Select Number Tab (top)>Secect Custom (List)>Select 0 in the Type: (right side)
Enter 3 more zero's for a total of 4
Cell A1 should have four zero's
Select cell A1 and place coursor at right hand lower corner.
Hold down the left mouse button and Drag the cross hairs down to cell A2.
Click cell A2 and delete the 0000.
Enter this formula =A1+1 in cell A2 (This will add 1 to 0000
You should now see 0001 in cell A2
Click Cell A2 and place the cursor over the right lower corner until you see a cross hair
Hold down the left mouse button and drag all the way down to cell A10000
You should now have Pick 4 combinations from 0000 through 9999
The last thing you should do is highlight the entire column "A"
Right click>Select copy
Right Click>Paste Special
Select "Values" under the Paste: column and Select OK
Now you can add more to this worksheet by entering formulas for positions 1 through 4 in cell columns B1 through E1