Colleagues, please tell me the answer to the following question!
If I use the RAND function with a range of output values greater than ten, is it possible to make it produce numbers with the same number of digits?
In other words, can RAND supplement the output number with zeros to the number of digits of the maximum value?
Well, for example,
not 1,2,3,4,5,6,7,8,9,10
but 01,02,03,04,05,06,07,08,09,10.
Or 001,002,003, … 100
Potentially you could try using a combination of MATH and RAND functions with variable manipulation to add a larger integer and then remove the leading digit:
Thank you. The method is witty. He reminded me of an old french anecdote about a strange but subtle perversion. (I really hope that I did not offend you!)
Colleagues, thank you very much for your recommendations!
They helped me advance in solving the problem, but most importantly, I was able to appreciate the window of real opportunities.