How to Add a Zero in Front of a Number in Excel - Tutorial

Excel tutorial on how to add a zero in front of a number in Excel, or what is sometimes called "leading zeros."

Knowing how to add a 0 as the first number in Excel can be tricky. Especially if you have to figure out how to add the right number zeros in front of them.

In this Excel tutorial, we go over 3 ways to add a zero in front of a number in Excel.

1. We first add a zero in front by using an apostrophe and the zeros in each cell. This converts your numbers to text format, letting you add however many leading zeros you want.

2. We, next, insert a zero before a number by using the REPT function.

3. The third way we add leading zeros in front of cells is by using Custom Formatting.

00:00 - Intro on How to Add Zeros in Front of a Number in Excel (i.e., Leading Zeros)
00:30 - How to Add a Zero Before a Number by Using an Apostrophe
01:28 - Learn Ways to Use the REPT Function to Insert Zeros in Front of Numbers
03:40 - See How to Apply Custom Formatting to Add 0 in Front of a Number

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[OliviaAmon-ymon]

Thank you soo much, i just impressed my boss, you made it so easy to understand, thank you once again.

[muddassirabbas]

Your video is very helpful, keep it up

[AmiyaRanjanNayak]

thanks a ton. This is amazing. you solved my problem within a minute for which I was worried for more than an hour.

[henrytluanga]

thanks, , the last one is very easy and the best

[sonyaesquire]

I’ve been looking everywhere for a video to help me perform this function!! Thank you sooo much!!! You helped save my grade! ❤❤❤

[calebbrumbaugh]

I would just like to say how grateful I am that I came across your video. I have spent hours on Excel trying to figure out how to format.

[savanalexis]

Thanks so much ...The second step was brilliant i was looking for this step 🙏🙏👍👍

[Inquisitive]

This was amazing. I needed that REPT and Length function as it gives me a number that I can use as a reference in my Index Match/ VLookup formula. Just changing the format to custom format does not bring the zero in the number. The Rept and LEN function solved my problem. Thank you so much!! well done!! Brief and to the point!

[arifzac]

Never knew Rept function before. Love it
Thank you so much

[Yuzarsif]

I had to subscribe immediately after you solved my problem.. Thanks a lot 🙏🌹

[WalkerB]

Brilliant... The last example, so simple when you know

[imranmalik.youtube]

It really helps, a big thumbs up for you

[sayangchen]

Thanks so much for your clear explanation and simple way to fix all different cases, it is work well for my report

[reena]

I Really Thank You From The bottom of my heart...
Thank You..
You solved my problem...
With love from India

[serrico]

Thank you, I did this 1:42 and it worked as intended.