Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi, I'm using Excel 2003 to do some actuarial work. I notice that if a very
large number of random number is generated(say 10000), and the spreadsheet is run by Macro for a large number of times(say 1000), sometimes, Excel 2003 will generate some negative random numbers, which is nonsense. Some of my friends told me earlier versions of Excel didn't have that problem. I'm sort of wondering what is going on with Excel 2003 random number generator and if Microsoft is going to develop a update to fix 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/comm...lic.excel.misc |
#2
![]() |
|||
|
|||
![]()
Hi
This is a bug. See http://support.microsoft.com/kb/834520/ HTH. Best wishes Harald "JJ" skrev i melding ... Hi, I'm using Excel 2003 to do some actuarial work. I notice that if a very large number of random number is generated(say 10000), and the spreadsheet is run by Macro for a large number of times(say 1000), sometimes, Excel 2003 will generate some negative random numbers, which is nonsense. Some of my friends told me earlier versions of Excel didn't have that problem. I'm sort of wondering what is going on with Excel 2003 random number generator and if Microsoft is going to develop a update to fix 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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel random number | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Random number generator | Excel Worksheet Functions |