Hi KJTFS!

This is a known bug. If you do a Google Search on RAND() you'll find
quite a lot has been written on it.

Try downloading Ron de Bruins Google Search 6.0 for easy searching
from Excel in Excel (and other) groups:

http://www.rondebruin.nl/Google.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.