When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...

If you want to keep the leading zeros in Excel as it is to input numeric data like account numbers, postal codes, phone numbers, etc., this post will show you how.