How to Generate Random Numbers in Excel 2003

1. Open an Excel spreadsheet.
2. Click on a cell where you want your range of random numbers to start.
3. Enter the following into the formula box:=RAND()and hit 'Enter.' This is the default RAND function and will generate the first random number between 0 and 1 to 9 decimal places. You can expand the cell to see all 9 decimal places. To generate a whole random number between numbers other than 0 and 1, enter the following into the formula box: =INT(RAND()*(b-a)) awhere 'a' is the minimum random number you want and 'b' is the maximum random number you want. For example, to generate random numbers between 1 and 100, you would enter: =INT(RAND()*(100-1)) 1.
4. Click on that cell, then move your mouse to the bottom right corner until a solid, black cross appears.
5. Drag this black cross down or across the number of cells that you want. For example, if you want to generate 20 random numbers, drag the cursor down 19 additional cells. All the cells, including the first one should now have a new random number.