Create a Random Number for use as Passwords with Excel
As a network administrator you will most likely get asked to create a list of users and import those users into a new application or domain. I’ve found that creating these users in Excel and saving as a CSV file to be the easiest way to do this for most circumstances as excel is great with working with tabled data and you can manipulate strings.
To create a random number of any length to be used as a password I tend to use the following function within excel:
=((RAND()*(10-1))+1)*100000)
This will create a 6 digit number between 100000 & 999999. For a 4 digit password replace the 100000 with a 1000.
Next you will need to remove the decimal places. Do this by clicking on the “Format Cells: Number” button circled in the picture below.
Next select Number from the category and place a zero in the decimal places section.
Now save the document out as a CSV and away you go.
Microsoft Office | Wayne | 
February 12, 2009 8:03 am