We might need to generate random numbers in Excel at times. Random numbers can be used to generate data encryption keys, simulate and describe complicated events, and select random samples from bigger data sets, among other things. In this article, we will demonstrate different ways to make the 4-digit random number generator Excel.

**Table of Contents**Expand

**4 Digit ****RandomÂ ****Number Generator in Excel: 8 Examples**

**1. Insert RANDBETWEEN Function to Generate 4 Digit Random Number**

**The RANDBETWEEN function** is classified as a Math and Trigonometry function in Excel. The **RANDBETWEEN **function in Excel generates a random value among two values. Each instance a spreadsheet is accessed or altered, **RANDBETWEEN** generates a new one. Letâ€™s generate 4-digit random numbers using this function. For this, we need to follow the steps down.

**STEPS:**

- Firstly, select the cell where you want to put the formula using the
**RANDBETWEEN**function. So, we select cell**B5**. - Secondly, put the formula into that selected cell.

`=RANDBETWEEN(1000,9999)`

- Thirdly, press
**Enter**.

- Now, drag the
**Fill Handle**down to duplicate the formula over the range. Or, to**AutoFill**the range, double-click on the**Plus**(**+**) symbol.

- Finally, we are able to see
**4**digit random numbers in the cell range**B5:B9**.

**2. RANDARRARY Function as Random 4 Digit Number Generator in Excel**

The **RANDARRAY **function generates a random number array. The number of rows and columns to fill, the minimum and maximum values, and who should return entire numbers or decimal values are all options. We can use the **RANDARRAY **function to generate 4-digit random numbers. So, letâ€™s look at the procedures below.

**STEPS:**

- To begin with, choose the cell where you want to insert the
**RANDARRAY**functionsâ€™ formula. - Second, type the formula below into the selected cell.

`=RANDARRAY(5,1,0,9999,TRUE)`

- Finally, press the
**Enter**key to finish the procedure.

This will automatically generate **4 **digit random numbers into five-row, as we put the number of row **5 **into the formula.

**3. Produce 4 Digit Random Numbers with TRUNC and RAND Functions**

**The TRUNC function** in Excel produces a truncated number with an optional number of digits. The fractional part of the value is removed by **TRUNC**. **The RAND function** returns a random specific number that is more than or equal to **0 **but less than **1**. We can combine the **TURNC **&** RAND** functions to generate 4-digit random numbers. Letâ€™s look at the steps to use the combination of those two functions to produce 4-digit random numbers.

**STEPS:**

- Similarly, as previous example, select cell
**B5**and substitute the formula

`=TRUNC(RAND()*9999,4)`

- Then, press
**Enter**. The formula will be shown in the formula bar.

- Further, to copy the formula over the range, drag the
**Fill Handle**down or**Double-click**on the**Plus**(**+**) icon.

- And, thatâ€™s it! You can see the result in column
**B**.

ðŸ”Ž **How Does the Formula Work?**

**RAND()*9999,4:**The**RAND()**Â will generate a random number between**1 to 9**. Multiplying**9999**will increase the number range and the**4**will return only the 4-digit of that random number.**TRUNC(RAND()*9999,4:**This will return the 4-digit of the random number.

**4. Combine ROUND & RAND Functions to Generate 4 Digit Random Number**

**The ROUND function** in Excel produces a number that has been trimmed to a specified number of digits. The** RAND **function in Excel generates a random value between 0 and 1**.** We can generate 4 digit random numbers by merging those two functions. So, letâ€™s follow the steps to do that.

**STEPS:**

- In the same way as before, firstly, select the cell where you want to put the formula to generate random numbers. So, we select cell
**B5**. - Secondly, enter the below formula into that selected cell.

`=ROUND(RAND()*(9999-1000)+1000,0)`

- After that, hit the
**Enter**key.

- After that, drag the
**Fill Handle**down to copy the formula over the range. Or, double click on the**plus**(**+**) sign. This also duplicates the formula.

- And, this will generate 4-digit random numbers into column
**B**.

ðŸ”Ž **How Does the Formula Work?**

**RAND()*(9999-1000)+1000,0:**This will mainly multiply**RAND()**with**9999**to generate only 4-digit random numbers.

**ROUND(RAND()*(9999-1000)+1000,0):**This will remove the extra decimal numbers and generate only the 4-digit numbers.

**5. Generate 4 Digit Random Number Using LEFT & RANDBETWEEN Functions in Excel**

**The LEFT function** returns the first character or characters in a text string based on the number of characters given. We can combine **LEFT **and **RANDBETWEEN **functions to generate 4-digit random numbers. So, letâ€™s follow the procedure.

**STEPS:**

- As shown in the earlier examples, firstly, select the cell and insert the formula into that cell.

`=LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999),B5)`

- And, press
**Enter**.

ðŸ”Ž **How Does the Formula Work?**

**RANDBETWEEN(1,9):**This will allow taking a number between**1**to**9**.**RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999),B5:**This line of formula will generate random numbers based on the number we put in cell**B5**.**LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999),B5):**This will return the first numbers based on number in the cell**B5**is given.

**6. Create 4 Digit Random Number by Combining INT & RAND Functions**

**The INT function** in Excel is used to return the closest integer of a given number. When we have a huge number of data sets and each data set is in various formats, such as float, this function returns the integer portion of the number. Letâ€™s follow the steps below.

**STEPS:**

- Likewise the previous examples, first, select cell
**B5**. - Then, in that selected cell, type in the formula below.

`=INT(RAND()*(9999-1000)+1000)`

- Finally, hit the
**Enter**key to complete the process.

- The result will now display in the selected cell, along with the formula in the formula bar.
- Further, drag the
**Fill Handle**down to duplicate the formula across the range. Alternatively, to**AutoFill**the range, double-click the**Plus**(**+**) symbol.

- Thatâ€™s everything for now! Last but not least, column
**B**shows 4-digit random numbers as a result.

ðŸ”Ž **How Does the Formula Work?**

**RAND()*(9999-1000)+1000:**This will mainly multiply**9999**with the**RAND**function to generate 4-digit numbers.**INT(RAND()*(9999-1000)+1000:**This will take the closest integer of the random number and generate only the 4-digit on random numbers.

**7. Use Excel Analysis ToolPak to Generate 4 Digit Random Number**

There is another way to inject 4-digit random integers that do not require the use of a formula. To generate random data, we can utilize the **Analysis ToolPak** add-in, but we must first install it. The **Analysis ToolPak** add-in can be installed in the main procedures. If you are using Microsoft Excel 365, it is installed by default. Now, letâ€™s see the procedure to use this add-in.

**STEPS:**

- Firstly, select the
**File**tab on the ribbon.

- Secondly, Click
**Options**. Or, use the keyboard shortcut**Alt + F + T**.

- This will open the
**Excel Options**dialog. - Then, Click
**Add-Ins**in the pop-up windowâ€™s left sidebar. - After that, select
**Analysis ToolPak**in the**Add-ins**section. - Further, select the
**Excel Add-ins**menu at the bottom of the main window from the**Manage**drop-down bar. - Next, click the
**Go**button.

- This will open a pop-up window with a list of all accessible Excel
**Add-ins**. - Checkmark the box
**Analysis ToolPak**and click**OK**.

- Furthermore, go to the
**Data**tab from the ribbon. There is now an extra category named**Analysis**on the Excel ribbonâ€™s**Data**tab, with one button labeled**Data Analysis**. Click on that.

- This will appear in the
**Data Analysis**dialog box. - Here, select
**R****andom Number Generation**and click**OK**.

- Again, a dialog box will appear named
**Random Number Generation**. - Type the number of columns in the
**Number of Variables**text box and type the number of rows in the**Number of Random Numbers**text box. - In the
**Distribution**drop-down menu bar, select**Uniform**. - Take the range for a 4-digit number. As we take a range between
**1000**and**9999**. - In the
**Output options**, select**Output Range**. So, we select**$B$5:$B$9**. - After that, click on the
**OK**button.

- And, finally, we will be able to see the result in the selected range.

**8. Excel VBA to Produce 4 Digit Random Number in Excel**

We can use **Excel VBA **to generate random numbers in specific cells. With **Excel VBA**, users can easily use the code which acts as an Excel menu from the ribbon. To use the **VBA **code to generate 4-digit random numbers, letâ€™s follow the procedure.

**STEPS:**

- In the first place, click the
**Developer**tab on the ribbon. - Secondly, launch the
**Visual Basic Editor**by clicking on**Visual Basic**. - Alternatively, you may access the
**Visual Basic Editor**by pressing**Alt + F11**.

- Instead of doing this, you can just right-click on your worksheet and go to
**View Code**. This will also take you to**Visual Basic Editor**.

- This will appear in the
**Visual Basic Editor**where we write our codes to create a table from range. - And, copy and paste the
**VBA**code shown below.

**VBA Code:**

```
Sub FourDigit_RandomNumber()
Dim num As Integer
num = Int((9999 - 100 + 1) * Rnd() + 100)
Range("B5") = num
End Sub
```

- After that, run the code by clicking on the
**RubSub**button or pressing the keyboard shortcut**F5**.

- And, finally, following the steps will generate a 4-digit random number in cell
**B5**.

**Download Practice Workbook**

You can download the workbook and practice with them.

**Conclusion**

The above examples will show you the Random 4 Digit Number Generator in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!

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