Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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/comm...lic.excel.misc |
#2
![]() |
|||
|
|||
![]()
See http://support.microsoft.com/default...b;en-us;834520
Bob Umlas Excel MVP "JJ" wrote in message ... 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/comm...lic.excel.misc |
#3
![]() |
|||
|
|||
![]()
Download current hotfixes. MS fixed this over a year ago.
Jerry JJ wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
How do you create a random number generator in Excel? | Excel Worksheet Functions | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel |