| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I get some negative numbers when I use the RAND() function--Why?
can anyone help me?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I get some negative numbers when I use the RAND() function--Why?
I think that this was a problem in early versions of xl2003.
There was a service pack that fixed this problem. If you click on Help|about, what version (including service pack) do you see? If it's xl2003 and not SP2, then it's off to microsoft.com to get the update. CaliDave wrote: can anyone help me? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I get some negative numbers when I use the RAND() function--Wh
Thanks Dave, All I see when I look in About is "Microsoft Office Excel 2003"
When I check my System Info, Version list "5.1.2600 service Pack 2 Build 2600" Is this what you are talking about or is there a specify SP for Excel? If so, where on the site can I find the update? Thx again... dave- "Dave Peterson" wrote: I think that this was a problem in early versions of xl2003. There was a service pack that fixed this problem. If you click on Help|about, what version (including service pack) do you see? If it's xl2003 and not SP2, then it's off to microsoft.com to get the update. CaliDave wrote: can anyone help me? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I get some negative numbers when I use the RAND() function--Wh
Nevermind, I found the it: 833855 (http://support.microsoft.com/kb/833855/)
Excel 2003 hotfix package: February 29, 2004 Never thought it be this easy. "CaliDave" wrote: Thanks Dave, All I see when I look in About is "Microsoft Office Excel 2003" When I check my System Info, Version list "5.1.2600 service Pack 2 Build 2600" Is this what you are talking about or is there a specify SP for Excel? If so, where on the site can I find the update? Thx again... dave- "Dave Peterson" wrote: I think that this was a problem in early versions of xl2003. There was a service pack that fixed this problem. If you click on Help|about, what version (including service pack) do you see? If it's xl2003 and not SP2, then it's off to microsoft.com to get the update. CaliDave wrote: can anyone help me? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I get some negative numbers when I use the RAND() function--Wh
I would have guessed that one of the SP's included that fix, but glad you got it
working. CaliDave wrote: Nevermind, I found the it: 833855 (http://support.microsoft.com/kb/833855/) Excel 2003 hotfix package: February 29, 2004 Never thought it be this easy. "CaliDave" wrote: Thanks Dave, All I see when I look in About is "Microsoft Office Excel 2003" When I check my System Info, Version list "5.1.2600 service Pack 2 Build 2600" Is this what you are talking about or is there a specify SP for Excel? If so, where on the site can I find the update? Thx again... dave- "Dave Peterson" wrote: I think that this was a problem in early versions of xl2003. There was a service pack that fixed this problem. If you click on Help|about, what version (including service pack) do you see? If it's xl2003 and not SP2, then it's off to microsoft.com to get the update. CaliDave wrote: can anyone help me? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "find and replace" negative numbers | Excel Worksheet Functions | |||
| How do I replace negative numbers with zero in Excel. | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
