To add zero at the front of a number in Excel, which automatically removes zeros at the beginning of a number, select the cell with your number, type an apostrophe and the number of zeros you need, and press** Enter**.

Read on to learn alternate methods and tricks to ensure your number doesn’t lose its zero at the beginning.

## Method 1: Using the Apostrophe

**Difficulty**: Beginner**Time Estimate**: 10 Seconds

1. Click on the cell with the number that starts with a zero.

2. Type an apostrophe and then add the number of zeros you need at the beginning of the number.

3. Press the **Enter** key on your keyboard.

Easy peasy! That’s all it takes.

## Method 2: Using the Number Format

**Difficulty**: Beginner**Time Estimate**: 15 Seconds

1. Select the cell where you want to add a zero at the beginning of a number.

2. Navigate to the **Home** tab.

3. Click on the small arrow to the right of the **Number Format** menu to expand the menu.

4. Pick the **Text **option.

5. Enter a zero in front of the number.

Voila! Changing the cell from a “number” value to a “text” value allows you to keep the zero at the beginning.

## Method 3: Using Formulas

**Difficulty**: Beginner**Time Estimate**: 15 Seconds

### Formula 1

1. Pick the cell where you need the number starting with a zero.

2. Go to the **Formula** bar and type **=REPT(0,2)&A1**, where **2** is the number of zeros you need to add and** A1** is the cell with the number to be changed.

3. Hit the **Enter** key.

Piece of cake! Let’s move on to the other formulas.

### Formula 2

1. Click on the cell where you want the new number starting with zero.

2. In the **Formula** bar, enter **=TEXT(A1,00)**. Here, **A1** is the cell with the number to be changed and **00** represents the zeros you need to add.

3. Press the **Enter** key on your keyboard.

And there you go!

### Formula 3

1. Select the cell where you want the number.

2. Navigate to the Formula bar and type **=CONCAT(“00”,A1)**, where** 00** represents the zeros you need to add and **A1** is the cell with the number to be changed.

3. Press **Enter**.

As simple as that!

## Zero in Front of a Number FAQs

Have any more questions? Let’s take a look at the most frequent inquiries and their answers.

### What are leading zeros used for?

Leading zeros are often used to ensure that a number is entered correctly. For example, if you type **005** into a cell, it will be saved as** 5**. When you’re dealing with a lot of data, it’s extremely useful to have this feature.

Leading zeros can also be used for aesthetic purposes. For example, if you are entering a list of serial numbers, you may want to add leading zeros so that all of the numbers have the same number of digits.

### Why does Excel not allow a zero at the beginning of a number?

One common issue people face is that Excel does not allow them to add a zero at the beginning of a number. This can be extremely frustrating, especially if you’re dealing with a lot of data. There are a few reasons why this might happen.

- The
**first reason**is that Excel interprets numbers that begin with zeros as octal numbers. Octal numbers are used in some programming languages, but they are not commonly used in Excel. As a result, if you enter a number that begins with a zero, Excel will remove the zero and display the number accordingly.

- The
**second reason**is that Excel saves numbers as floating-point numbers. This means that there is a certain amount of precision that is lost when a number is stored in a cell.

- The
**third reason**is that Excel has a limited number of digits that it can store in a cell. If a number is too long, Excel will simply truncate it. This means that any leading zeros will be lost.

### Are leading zeros ever significant?

In some cases, leading zeros are significant, and in other cases, they are not. For example, if you were entering a list of ID numbers into Excel, the leading zeros would likely be significant. On the other hand, if you were entering a list of prices, the leading zeros would not be significant.

### Why do we put a zero before decimal?

We put a zero before a decimal primarily to avoid confusion and to emphasize the fact that it is a decimal number. Some also do this to make the number reflect how it’s said.

For example, when we write **0.25**, we are saying **zero point two five**, but if we wrote just** .25**, it would look like we’re saying **point two five**. Including the zero helps to clarify the number.