Display Zero(0) at Starting of Numbers/Integers in Excel

Introduction

Here. I will show you "How you can Display Zero (0) at the Starting of the Numbers/Integers in Excel".

If you have ever tried to Enter a numerical value starting with 0, then you must have faced problems, as the Excel displays the numbers after the "0" and the "0" itself is dropped.

This thing happens because the numerical values don't start from "0"; only the text does.

So, if you want to display the "0" at the beginning of the Numerical value, then you must use something which can concatenate the text with the numbers.

For this thing to happen, this formula will help us:

=RIGHT(CONCATENATE("00000",A1), 6)

Click on the Cell where you need to enter the "0" and provide this code in the formula section.

Like here I had done:

Now press enter button and you will see a 0 in the cell:

This formula will allow you to enter atmost 6 values. You can provide your numerical value in place of "A1" like here I had done:

=RIGHT(CONCATENATE("00000",123), 6)

Now, if you will click enter, you will be able to see three 0's at the beginning and 123: