HOW TO ENTER PHONE NUMBER IN EXCEL WITHOUT LOSING NUMBER 0

While entering phone numbers in Excel, we often have the problem of losing the first zero, so how to enter the full phone number simply and quickly.

This article will introduce you to 4 simple ways to enter a phone number:

Way 1: Format the cell containing the phone number to Text

• Right click on the cell containing the phone number, select Format Cells then choose Text
• Enter your phone number.

Method 2: Enter a “-” or a “.” into the phone number to convert the numeric data into a text string.

Way 3: Add ‘ in front of the phone number to enter.

Way 4: Entering extra spaces in between phone numbers is also effective.