How to Enter Zero Before a Number in Excel

excel logo

When entering numbers into Excel, zeros at the beginning of the number are removed. This can be an issue when entering phone numbers and IDs. In this article, we will cover ways to solve this problem and keep the leading zeros.

Keep the Leading Zero as you Type

If you wanted to ensure that the leading zero is kept when typing, enter a single quote before you type the number.

Sinlge quote before phone number

This instructs Excel to store the value as text and not as a number.

When you press “Enter” to confirm, a green triangle is shown in the top left corner of the cell. Excel is checking that you intended to do that or if you want to convert it to a number.

Click the diamond icon to display a list of actions. Select “Ignore Error’ to proceed and store the number as text.

Phone number stored as text in Excel

The green triangle should then disappear.

Apply Formatting to Keep the Zero

Read the remaining 17 paragraphs

Source: https://www.howtogeek.com/434261/how-to-enter-zero-before-a-number-in-excel/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Alan Murray

Author: Droolin' Dog News Team