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
👉 https://www.howtoexcel.org/courses/

DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/

SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/

CONNECT with me on social
Facebook:   / howtoexcelblog  
Twitter:   / howtoexcelblog  
LinkedIn:   / john-macdougall  

Thanks for all your support!