Random Number Generator

Hi All,

I'm not sure if this is the right forum for this, but here it is: I want to generate random numbers with a normal distribution around 0. I know that this is fairly simple using the random number generator in the data toolpack, but the problem is when I run the generator and put the output to say A1:A100 it's not actually random. What I mean is if I run the output to A1:A100 then B1:B100 then C1:C100 they all have the same values. I tried opening a new workbook and it gave me the same values. Any help here?

Thanks!

Are you using =NORMINV(RAND(), Mean, StdDev)?

I hadn't been using that, but that works. Thanks.