I have posted this question in the wrong place, so here I am again.

I want to generate a random number using RAND() in a cell.

But the number generated by RAND() will change every time there is a
recalculation.

Once the number is generated, is there a way to make it NOT to change under
any situation?

Thanks in advance

Charles.