8 Ways to Add Leading Zeros to Numbers in Excel

In this video we're going to look at 8 different ways to add leading zeros to your numbers in Excel.

Table of Contents:
1. Custom Format 0:08
2. Format as Text 0:56
3. Leading Apostrophe 1:47
4. TEXT Function 2:14
5. RIGHT Function 2:51
6. Power Query and Text.PadStart Function 4:20
7. Pivot Table and DAX Measure 6:39
8. Power Pivot Calculated Column 9:31 👇

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here:

[islandofrobgaming]

Thank you dude you saved me hours of trying to work that out!

[wayneedmondson]

Hi John.. cool.. thanks for the tips. Also.. thanks for continuing to post new videos during this stressful and troubling time. Nothing better than improving our Excel skills during the lock-down while we all wait this thing out. Thumbs up for How to Excel and stay safe out there!!

[docmacg]

As a new user this was a little overwhelming but I do appreciate the numerous ways to do this as I practice.

[AjayAnandXLnCAD]

Awesome methods John. Learned a lot of new things.

[renedanos]

Hey John. I use the Custom Format pretty much daily. It is very useful for loading asset numbers that have to always be 7 digits. My question is why they don't appear in the formula bar when you click on one? it only shows the original number.

[SachinTawadeSachin_vst]

It's gr8 to know many ways to do a thing, I thing you can use repeat function also to get leading zero 😉
=Rept("0", 12-len(a1))
Here i used 12 becoz I want to get max 12 digit

[peterkohl]

I would like to add a 0 in the time for single digit hours IE. 07:10 hrs cannot seem to format as it always removes t he 0 which i add

[raju]

i am not able to use the file after i saved and open it as normal format (with leading zero in csv)...i need to export the csv file with infront of zero leading to other applications? can you please help me on this

[taraeasley]

I'm having an issue where I need to add leading zeros after text. So in your "right function" example, how would I add leading zeroes BETWEEN the text and the numbers? For example, "A0001" and "B0002".

[Osmanfayyaz]

In Power Query, I am unable to enable M Intellisence
Can you guide me
I have subscription based office with semi annual channel Update
and Particular update came on 14 Jan-2020 by Microsoft
At the moment I have latest build 14 Apirl
In Power Query Editor, I am unable to find M Intellisence whether I have to install something (any specific software)

[serpoushsoroush]

Thanks for your videos. But you speak very fast . Could you add subtitle for better learning.

[doombringer]

8 ways? Good grief! Can Excel just put a fuc*ing zero where I want one? SIMPLE. All the "options"! The next one is more complicated than the last!