How to keep zero in front of a number in Excel

How to keep zero in front of a number in Excel

If you enter large numbers like 003-435-556-578 in any row or column of an excel sheet, if the recently recorded number has leading zeros, excel will automatically omit the leading zeros. This action can be offending and annoying especially when you do not know how to insert back your zeros. Large numbers like the one