|Posted: January 2, 2006, 2:27 pm - IP Logged|
put them into a text file (notepad.exe) first, then import into the excel sheet from
the Data menu item
--> Import External Data submenu
------->Import Data... on the sub-sub menu
this opens up the "Select Data Source" dialog box.
let's say you have a text file named "Drawings.txt" containing the following data...
you select the drawings.txt file from the Select Data Source dialog box (after navigating to it's location)
this opens the Text Import Wizard...
Step one of 3... choose the Delimited Radio button (default) because the numbers are separated by a character such as - or , etc...
Step 2 of 3... choose the delimiter (check the "Other" box and in the space provided, enter a - )
Step 3 of 3... select data formats (you can skip this unless you are also importing a date, then simply make the date column the DATE data type and skip the rest)
click Finish...then select the cell where you want the data (A1 by default on a blank sheet)
and it goes right into the worksheet.
Playing more than one ticket per game is betting against yourself.