Convert it to values???

select your range
edit|copy
Edit|paste special|values



ScottC wrote:

How do I Stop RAND() recalculating each time I open spreadsheet

--

Dave Peterson