RAND() generates negative values???

[expect_ed]

Office 2007 - Even though the description says:
"Returns a random number greate than or equal to 0 and less than 1, evenly
distributed (changes on recalculation)."
When I enter the formula and extend the cell down the column I get negative
values.
What gives?

 

[Mike H]

Hi,

If =RAND() is generating negatives then something else is going on. Post the
formula you used.

Do you have any event code running on the sheet?
Do you have any formatting in the cells?

Mike

 

[T. Valko]

I just tested RAND in Excel 2007 SP1 through 20 million iterations and did
not get a single negative number.