To generate random phone numbers we will use the Rand function in Microsoft Excel 2010.
Rand: – Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).
Syntax of “RAND” function: =RAND()
Note: When you press any key on your keyboard formula will change the number automatically.
Let’s take an example and understand how we can generate the random phone numbers in Microsoft Excel.
To return the random phone numbers follow below given steps:
We have to format it in phone number format for the proper view of phone numbers.
Note: We have to convert formulas in the value, because when you press any key on your keyboard and when you will open the file every time numbers will get change.
To convert the formula in to values we will use the Paste special option.
This is the way we can generate Random numbers with Excel Rand function in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.