Comments on: Build a Random Number Generator in Google Sheets in 2 Mins https://spreadsheetpoint.com/generate-random-numbers-google-sheets/ Google Sheets Tips & Tutorials Tue, 15 Aug 2023 08:05:26 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: Kathrine Joen https://spreadsheetpoint.com/generate-random-numbers-google-sheets/#comment-9703 Wed, 08 Jun 2022 15:17:23 +0000 https://spreadsheetpoint.com/?p=2745#comment-9703 Thank you so Much! Just what I was looking for – one question though: Is it possible to set it to show e.g. 7 numbers? When I do the code (=TRUNC(RAND() * (10000 – 1) + 1)) some of the numbers are only 3 characters others are 5 characters. Is it possible to set a specific outcome of characters?
Kind regards, Kathrine

]]> By: Matthieu https://spreadsheetpoint.com/generate-random-numbers-google-sheets/#comment-9565 Sat, 14 May 2022 13:08:54 +0000 https://spreadsheetpoint.com/?p=2745#comment-9565 Is there a way of generating a random number and then reporting it as a fixed unchangeable number in another cell?

]]>