Go to Tools, Data Analysis, Random Number Generation and choose the
distribution giving your required mean and standard deviation. The mean and
standard deviation of the list generated will not be exactly the same as
those you entered. First multiply every item by the required standard
deviation divided by 6.2. You will now have the required standard deviation.
The mean will also have changed. Add the required mean minus the new mean to
every item.

"Randi R" wrote:

How do I generate random numbers from a normal distribution in excel? I want
to generate a set of random numbers with a normal distribution of
(mean=162.7, standard deviation=6.2)