Tanim -

(1) For random numbers from a normal distribution, use =NORMINV(RAND(),6,10)

(2) You cannot change the seed of the worksheet function RAND. (a) If you
write Excel VBA, you can use the Excel VBA RND function for random values of
your custom user-defined function, and you can use the Excel VBA RANDOMIZE
statement to set the seed. (b) Third-party add-ins for Excel allow you to
specify the seed for their random number generator functions, e.g., my
RiskSim add-in with free tryout available from www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Tanim" wrote in message
...
In Excel 2007, how can I create random numbers around a mean of 7 or some
other specific number?

I have to generate 36 random numbers around the mean of 6 with standard
deviation of 10.

Also how can I change the seed in 2007?

Your help is greatly appreciated.