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.

Click here to read our step-by-step article on how to add a zero before a number in Excel: yacostasolutions.com/zero-in-front-excel/

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

On a related topic, make sure to watch my tutorial on the Leading Zeros Beta: youtu.be/SSV2JrFgJdE

If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/

*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365

The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia

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 😊

To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube

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