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

About this tutorial:

Video duration: 00:04:18
Excel tutorial on how to add a zero in front of a number in Excel, or what is sometimes called – leading zeros.

Have you ever had to deal with a set of numbers in Excel where 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…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads