In this video I demonstrate how to add a zero in front of a number in Microsoft Excel, or should I say - how to keep a zero in front of a number in Excel?

Excel will remove leading zeros from numbers unless you tell it that the number is text.

This video looks as four different methods of keeping leading zeros
1) Use an apostrophe
2) Format cells as text
3) Use the RIGHT function
4) Use custom formatting

This video answers the following queries:
How do I add a zero in front of a number in Excel?
How do I add leading zeros in Excel?
How do I keep the 0 in front of a number in Excel?
How do you make Excel recognize 0?
What is the formula to add leading zeros in Excel?
How do I start a number with 0 in Excel?
How do I add leading zeros in Excel to a certain length?
Add leading zeros in Excel formula
How to put 0 in Excel in front of numbers
------------------------