=RAND() will give you a random number between 0 and 1. It changes anytime
the sheet recalculates.

If you need a value larger than 1, you can string a bunch of RAND's together:
=ROUND((RAND()+1)*(RAND()+20)*(RAND()*41),0)


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"autogenerated numbers" wrote:

Im trying to create a spreadsheet with database information but I want to
every time I open it have a diferent generated number in a determined cell.