how to add zero before any number in excel | how to add phone number in excel

Описание: In this video I have explained how to add zero before any number in excel and how to add phone number in excel. If someone wants to add a list of phone numbers in MS Excel, the zero in front of a number disappears as you press entre button. To avoid this problem, we add zero before phone number manually.
This video explain the simple and easiest method of how to add phone number in excel and how to add zero before any number in excel.
Not only the phone numbers, sometimes zero appears before the bank account numbers and other numbers. You will need to follow the same method to add zero before a number in excel.
Once you add a zero before number, you can copy the same format to all the given mobile numbers and you can add zero before all just by a small shortcut.