T
T
talto2020-05-12 13:23:54
random numbers
talto, 2020-05-12 13:23:54

How to generate random numbers, one for all users and without constant updates when changes are made?

Can you please tell me how to generate random numbers in Google Sheets that will not be recalculated with every change in the table?
Now they are changing steadily for me and for me and for a friend the values ​​\u200b\u200bare displayed different.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Daria Motorina, 2020-05-12
@talto

1) Create random numbers in any cells (not target)
2) Select and copy
3) Paste into the desired cells via RMB > "paste special" > "paste values ​​only"

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question