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

Method 1 – Combine ROUND and RAND Functions to Generate Random 10 Digit Number

STEPS:

• Enter the following formula in cell C5.

• Press Enter.
• It will return a random 10 digits number in cell C5.
• Drag the Fill Handle tool from cell C5 to cell C9.
• We will get the result as shown in the following image.

How Does the Formula Work?

Method 2 – Use RANDBETWEEN Function to Create Random 10 Digit Number in Excel

STEPS:

• Enter the following formula in cell C5.

• Press Enter.
• We will get a random 10 digits number in cell C5.
• Drag the Fill Handle tool for the remaining cells.
• The result will be as shown in the following image.

Method 3 – Generate Random 10 Digit Number Based on Number of Digits You Type in Different Cell

STEPS:

• Select the cells (D5:D9) and enter the following formula.

• Enter the value 10 in cell C5.
• Press Enter.
• We will get a random 10 digits number in cell D5.

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

How Does the Formula Work?

Method 4 – Apply RANDARRAY Function to Generate Random 10 Digit Number

STEPS:

• Enter the following formula in cell C5.

• Press Enter.
• We will get random numbers in cells (C5:D9).

Method 5 – Generate10 Digit Number with Analysis Toolpak

STEPS:

• Go to the File tab.

• Select Options from the menu.

• A dialog box named ‘Excel Options’ will pop up.
• Click on the option Add-ins on the left side of the window.
• On the right side, scroll down to the bottom. Select the option ‘Excel Add-ins’ from the drop-down and click on Go.

• This will open a pop-up window with a list of all accessible Excel add-ins. Click OK after checking the box ‘Analysis ToolPak’.

• Select the ‘Data Analysis’ option from the Data tab.

• It will open a new pop-up window named ‘Data Analysis’.
• Scroll down the options in the ‘Analysis Tools’ section. Select the ‘Random Number Generation’ option and click OK.

• We will get a pop-up window named ‘Random Number Generation’. We will input values for different parameters to generate random 10 digits 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 entered 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.
• Click on OK.

• Random 10 digits numbers will be generated in cells (C5:C9).

Method 6 – Insert VBA Code to Create 10 Digit Number in Excel

STEPS:

• Right-click on the active sheet and select the option ‘View Code’.

• The above command will open a new blank VBA code window for that worksheet.
• Enter 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

• Click on the Run or press the F5 key to run the code.

• We will get 10 digits numbers generated in cells (C5:C9).

Download Practice Workbook

<< Go Back to Random Number in Excel | Randomize in Excel | Learn Excel