Add a Zero In Front of a Number in Excel | Formula to Keep Leading Zeros to a Certain Length

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
------------------------

[baylee]

I spent so long trying to figure this out. The apostrophe method worked for me. Thank you

[tigerika]

thank you so much, you were the helpful video of all of them there, right to the point!!! Thank you!!!

[FarewellPerformance]

Thank you for this. I was looking for a way to add leading zero's with my countifs formula and your RIGHT function method worked perfect. Thanks again!

[counterhit]

Nice. The =RIGHT function was exactly what i needed.

[patriciastrauch]

This saved me so much time! It was exactly what I was looking for. Thank you.

[RandomShorts]

Thank you i was struggling before but no more because of you thanks god bless

[averagesalesguy]

You crushed it. This is what I was looking for.

[zyuth]

Finally!!! the 3rd method is what i'm looking for. not exactly the same but it help a lots, Ty

[s.m.shahedhossen]

Wonderful. Many thanks for your nice presentation.

[sitiaikhasyabintimohamakam]

Thank you for sharing these tips!! Very helpful.

[parthtiwari]

Thanks, man, for such an insight full video

[GCiova]

I struggle with the "zero" problem for years... thank you very much for these easy solutions

[sandycantu]

Thank you for your quick and easy explanations.

[IvanCortinas_ES]

Perfect Chester! A great video. Thank you for sharing these tips!!!

[jadenash]

this really helped me at work today thank you - quick and easy to follow - much love mwah

[benedictagyemang]

Very amazing content, thanks for sharing Sir Chester.

[chrisgillanders]

Brilliant. You're a life saver. Thank you

[brandanbaker]

This was very helpful. Exactly what I was looking for. Thanks Chester.

[historytraveler]

Great.ALL method works. i am using 2nd one method.

[pushparaj]

Excellent and informative video brother keep rocking