Buzz
When entering various types of number sequences such as phone numbers, identity card numbers, bank card numbers,... containing zero at the beginning of the sequence, Excel will automatically remove these zeros. This will make it really inconvenient when unable to input the entire sequence. However, there are many ways in Excel to help us overcome this issue. The article below will guide you through 3 ways to input zero in Excel, leading with double zeros.
Representing Zero in Excel, Leading Zero in Number Sequence
Method 1: Adding the ' character before the number sequence
This is the most manual and simplest way to write zero at the beginning of a number sequence in Excel. However, a drawback of this method is that if you have to input many numbers, adding the ' character before each one will also consume your time.
Example:
In this example, you can see that the ' character is added before each number sequence. However, when displayed, the ' character will be hidden and won't affect the display of the number sequence.
Method 2: Text Formatting for Number Sequences
This method will help you save a lot of time because you don't need to add the ' character before the number sequence like method 1 above.
Step 1: Select the entire area where you want to input zero at the beginning of the number sequence, right-click, and choose Format Cells
Step 2: In the dialog that appears, on the Number tab, select the Text format and click Ok to confirm
Step 3: Begin entering numbers as usual
Additionally, you can also perform formatting directly on the Ribbon => Number toolbar without opening the Format Cells.
Method 3: Inputting Multiple Leading Zeros
In some cases, if you need to input multiple leading zeros, you can also format Excel to automatically fill in these zeros for you.
Step 1: Select the entire area where you want to input zero at the beginning of the number sequence, right-click, and choose Format Cells
Step 2: In the dialog that appears, on the Number tab, select Custom format, enter the number of zeros you want to add before and click Ok to confirm
Note: The zeros you enter will count for your entire number sequence. For example, if your number sequence consists of 4 non-zero integers, and you enter a Custom format including 8 zeros, the result will only show 4 zeros at the beginning.
Step 3: Start entering numbers as usual, no need to enter any zeros at the beginning.
Here's a compilation of ways to write zero in Excel, leading with zero in number sequence. We hope that through this article, you will no longer encounter obstacles when entering information with zeros at the beginning.
Another trick we often receive questions about from readers is how to convert numbers to words in Excel without using any support tools, and you can still convert numbers to words in Excel following our instructions. Wishing you success!
If you still don't know how to select even or odd pages for printing, you can refer to the article How to Print Even or Odd Pages in Word, Excel, PDF previously shared by Mytour.
You will need to know how to delete rows and columns in Excel to delete any unnecessary or redundant rows and columns. Refer to the article Delete Rows, Columns in Excel 2016, 2013, 2010, 2007, 2003 if you're not sure how to do it.
