Great find! No wonder I couldn't duplicate it here (must have refreshed a
sheet 40 times trying) - I'm up to date on hotfixes.

"Biff" wrote:

See this:

http://support.microsoft.com/kb/834520

Biff

"SusanForson" wrote in message
...
I must be crazy, but I am using the RAND() function and it occasionally
generates a negative number. I cannot find any information on this - by
definition it should only generate numbers between 0 and 1.

Any suggestions?

Thanks in advance.

Susan Forson