generate random number in a column excel code example

Example: insert random numbers in excel

*Select the cells in which you want to get the random numbers.

*In the active cell, enter =RAND()

*Hold the Control key and Press Enter.

*Select all the cell (where you have the result of the RAND function) and convert it to values.