# How to Generate Random 10 Digit Number in Excel (6 Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, we will explain different methods to generate a random 10 digit number in Excel. While working on a project in Microsoft Excel sometimes we do not have any particular dataset. So, we have to create a sample one. While creating a sample dataset we may need to generate random numbers. Generally, we have to generate random numbers for a few instances. Itâ€™s not the kind of feature which we need to use frequently.

## How to Generate Random 10 Digit Number in Excel: 6 Methods

Throughout the whole article, we will explain 6 methods to generate a random 10 digit number. We will use different functions, tools, and VBA code.

### 1. Combine ROUND and RAND Functions to Generate Random 10 Digit Number

First and foremost, we will use the ROUND function and the RAND function to generate a random 10 digits number.

In Microsoft Excel, the RAND function returns a random number between 0 and 1.

The ROUND function in Excel produces a number that has been rounded to a specified number of digits.

The names of five people are shown in the following image from our dataset. Weâ€™ll generate phone numbers for them at random, each with ten digits.

Letâ€™s see the steps to perform this action.

STEPS:

• First, select cell C5.
• Next, type the following formula in that cell:
`=ROUND(RAND()*9999999999+1,0)`
• Press Enter.
• So, the above action returns a random 10 digit number in cell C5.
• Then, drag the Fill Handle tool from cell C5 to cell C9.
• Finally, we get results like the following image.

ðŸ”Ž How Does the Formula Work?

• RAND()*9999999999+1: This part multiplies the random number generated by 9999999999 and adds 1 to it.
• ROUND(RAND()*9999999999+1,0): This part rounds the result that we get from the RANDÂ function.

### 2. Use RANDBETWEEN Function to Create Random 10 Digit Number in Excel

In the second method, we will use the RANDBETWEEN function to generate a random 10 digit number in Excel.

The RANDBETWEEN function in Excel returns an integer number between two specified numbers.

To explain this method we will continue with our previous dataset.

Letâ€™s see the steps to execute this method.

STEPS:

• Firstly, select cell C5 and insert the following formula in that cell:
`=RANDBETWEEN(1000000000,9999999999)`
• Hit Enter.
• As a result, we get a random 10 digit number in cell C5.
• Secondly, drag the Fill Handle tool from cell C5 to the end of the dataset.
• Lastly, we can see the results in the following image.

Read More: Random 4 Digit Number Generator in Excel

### 3. Generate Random 10 Digit Number Based on Number of Digits You Type in Different Cell

In the third method, we will generate a random 10 digit number using a unique method. For instance, when we type 10 in cell C5, cell D5 will show a random number of 10 digits within it.

We will follow the below steps to perform this method.

STEPS:

• To begin with, insert the following formula in cells (D5:D9):
`=LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999), C5)`

• In addition, type the value 10 in cell C5.
• Tap Enter.
• Furthermore, we get a random 10 digit number in cell D5.

• Finally, input the value 10 in cells (C6:C9). As a result, we also get random 10 digit numbers in cells (D6:D9).

ðŸ”Ž How Does the Formula Work?

• RANDBETWEEN(0,999999999999999): This part returns a random 10 digit number.
• LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999), C5): Returns a random number of fixed digits in cell D5 that we type in cell C5.

### 4. Apply RANDARRAY Function to Generate Random 10 Digit Number

Another method to generate random numbers in a specific region in our dataset is to use the RANDARRAY function. The RANDARRAY function is only available in Microsoft Excel 365 & Microsoft Excel 2021 versions.

The RANDARRAY function provides a list of random numbers ranging from 0 to 1 which is specified by a number of rows and columns.

In the following dataset, we will randomly generate two phone numbers for each person with the RANDARRAY function.

Letâ€™s see the steps to use the RANDARRAY function.

STEPS:

• In the beginning, select cell C5.
• Next, type the following formula in that cell:
`=RANDARRAY(5,2,1000000000,9999999999,TRUE)`

• After that, tap Enter.
• Finally, we get random numbers in cells (C5:D9).

### 5. Generate10 Digit Number with Analysis Toolpak

Another method to generate a random 10 digit number in Excel is to use an Add-in named â€˜Analysis Toolpakâ€™. This method doesnâ€™t require any formula.

To illustrate this method we will use the dataset of our first method. Just follow the below steps to perform this action.

STEPS:

• Firstly, go to the FileÂ tab.

• Secondly, select Options from the menu.

• A new pop-up window appears named â€˜Excel Optionsâ€™.
• Thirdly, click on the option Add-ins on the left side of the window.
• Next, on the right side scroll down to the bottom. Select the option â€˜Excel Add-insâ€™ from the drop-down and click on the GoÂ button.

• This will open a pop-up window with a list of all accessible Excel add-ins. Click OK after checking the box for â€˜Analysis ToolPakâ€™.

• Then, select the â€˜Data Analysisâ€™ option from the DataÂ tab.

• It opens a new pop-up window named â€˜Data Analysisâ€™.
• Moreover, scroll down the options in the â€˜Analysis Toolsâ€™ section. Select the â€˜Random Number Generationâ€™ option and then click OK.

• After that, we get one more pop-up window named â€˜Random Number Generationâ€™. We will input values for different parameters to generate random 10 digit numbers.
• The â€˜Number of Variablesâ€™ field specifies how many columns we want to fill with random data. We have used the value 1.
• The number of rows is indicated by the â€˜Number of Random Numbersâ€™. We have taken the value 5.
• In the Distribution field, we have chosen the option Uniform.
• Set the parameters to a range of 1 to 9999999999.
• Set the â€˜Output Rangeâ€™ to the arrayâ€™s beginning which is cell C5.
• Now click on OK.

• Finally, we can see randomly generated 10 digit numbers in cells (C5:C9).

### 6. Insert VBA Code to Create 10 Digit Number in Excel

In the last method, we will generate a random 10 digit number with the use of a VBA code. To demonstrate this method we use the following dataset that we have also used earlier.

Follow the below steps to perform this method.

STEPS:

• To begin with, right-click on the active sheet and select the option â€˜View Codeâ€™.

• The above command opens a new blank VBA code window for that worksheet.
• In addition, insert the following code in the code window:
``````Sub Random_10_Digit()
Dim GRN As Integer
For GRN = 5 To 9
ActiveSheet.Cells(GRN, 3) = Round((Rnd() * 9999999999# - 1) + 1, 0)
Next GRN
End Sub``````
• Furthermore, click on the Run or press the F5 key to run the code.

• Lastly, we get 10 digit numbers generated at random in cells (C5:C9).

We can download the practice workbook from here.

## Conclusion

In conclusion, we can easily generate a random 10 digit number in Excel by following this method. To achieve the greatest results, download the practice workbook that has been attached to this article and put it to use. If you have any questions or recommendations, please leave a remark in the box below.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF