- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# How to generate a list of all possible 4 digits combinations in Excel?

In certain circumstances, it may be necessary for us to make a list of all of the conceivable four-digit combinations of the numbers 0 to 9, which would require us to generate a list that includes the digits 0000, 0001, 0002, and 99999. For a speedy solution to the list problem in Excel. It is possible that we'll need to produce random numbers in Excel at some point. Numerous tasks, including the simulation and description of complex occurrences, the selection of random samples from larger data sets, and the generation of data encryption keys can all be accomplished with the help of random numbers.

Within the scope of this articles, we will explore a variety of approaches to the creation of an Excel-based random number generator with four digits.

## Generate four Digit Random Number using RANDBETWEEN Function

In Excel, the RANDBETWEEN function may be found in the Math and Trigonometry section of the function library. Excel's RANDBETWEEN function is responsible for producing a random value that falls between two specified values. Whenever a spreadsheet is opened or modified, RANDBETWEEN will produce a nearly new one. Let's use this function to produce some random integers with 4 digits.

**Step 1**

In an excel sheet, select one cell and add the following formula in it. In our case we have selected B1 and added the formula in it.

=RANDBETWEEN(1000,9999)

After adding the formula, press enter. You will see a random number between 1000 to 9999 has been produced.

See the below given image.

**Step 2**

To reflect in other cells, click on the ‘+’ sign appears on the lower right corner of the cell B1, which activates the autofill function and then drag down.

See the below given image.

## Generate four Digit Random Number using TEXT Function

Excel's TEXT function takes a number and returns it in the format specified by the user as text. You can include formatted numbers within the body of text by making use of the TEXT function.

**Step 1**

In an excel sheet, select one cell and add the following formula in it. In our case we have selected A1 and added the formula in it.

=TEXT(ROW(A1)-1,"0000")

After adding the formula, press enter. You will see a combination of 4 digit numbers has been produced.

See the below given image.

**Step 2**

After that, pull the autofill handle to the bottom until all the possible combinations of 4 digits are listed.

- Related Articles
- How to generate or list all possible permutations in Excel?
- C++ Program to Generate All Possible Combinations of a Given List of Numbers
- How to generate all combinations of 3 or multiple columns in Excel?
- C++ Program to Generate All Possible Combinations Out of a,b,c,d,e
- Golang Program to Read Three Digits and Print all Possible Combinations from the Digits
- Python Program to Accept Three Digits and Print all Possible Combinations from the Digits
- Program to find list of all possible combinations of letters of a given string s in Python
- Generate all combinations of supplied words in JavaScript
- Python – All combinations of a Dictionary List
- How to generate all permutations of a list in Python?
- JavaScript function that generates all possible combinations of a string
- How to generate random value from a given list in Excel?
- Generate all combinations of a specific size from a single set in PHP
- Finding all possible combinations from an array in JavaScript
- Python - Generate all possible permutations of words in a Sentence