Excel random number

[Guest]

Hi, I'm currently using Excel 2003 to do some actuarial work. I notice that
when I generate a large number of random numbers(say 10000) and run the
spreadsheet through Macro for a large number of times(say 1000), sometimes,
negative random number appears. My friends told me earlier versions didn't
have that problem. I'm sort of wondering what is going on with the random
generator of Excel 2003, and if Microsoft if going to develop a update to
solve this problem.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-1ea5a11f0952&dg=microsoft.public.excel.misc

 

[Bob Umlas]

See http://support.microsoft.com/default.aspx?scid=kb;en-us;834520
Bob Umlas
Excel MVP

Hi, I'm currently using Excel 2003 to do some actuarial work. I notice that
when I generate a large number of random numbers(say 10000) and run the
spreadsheet through Macro for a large number of times(say 1000), sometimes,
negative random number appears. My friends told me earlier versions didn't
have that problem. I'm sort of wondering what is going on with the random
generator of Excel 2003, and if Microsoft if going to develop a update to
solve this problem.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-1ea5a11f0952&dg=microsoft.public.excel.misc

 

[Jerry W. Lewis]

Download current hotfixes. MS fixed this over a year ago.

Jerry