Question:-How I can Create Random Numbers in MS Excel?
Answer:-Create Random Numbers in MS Excel
Sometimes it's useful to have random numbers in a Microsoft Office Excel spreadsheet—even if it's just for creating test data. To put a random number in a cell, type the formula =RAND(). For bulk random numbering, copy that formula to a large number of cells—each will be random.