The Leading Zero Format in Excel Number Ranges Is Easy

In Excel, when entering the data of whole numbers such as 0916162537,01001235698,. it will automatically understand that this is a numeric format and will remove all zeros at the beginning, only take the whole part behind.

In the case where you may need to enter your phone number, tax code, invoice code,. then you must have leading zeros, what should you do?

Here are TipsMake introduce 3 ways:

Method 1: Type Extra Sign Before the Number Sequence

This is the most manual way: before typing a sequence of numbers with 0 before, you enter the quotes 'and then continue to enter the number:' 0919118119

Excel will automatically remove the quotes and display the number 0 before the number range and understand that this cell is formatted as Text

Method 2: Format fonts in Format Cells

With this type of format, you can freely press the number 0 without losing but fast, not time-consuming as the manual way above, that is:

+ After you enter the numbers, you will highlight the entire number of columns or rows, right-click and choose Format Cells

+ Format as Text - click OK

Method 3: Format fixed numbers in Custom

This way you can separate 3 or 4 numbers once you enter a phone number to easily follow the steps as follows:

In the phone number column, open the Format Cells dialog box, select Custom, in the Type line, enter the following:

0 ### ### ####

Then click OK.

Then, after entering the phone number will display as shown below:

If you do not want a space between 3 or 4 numbers, in Custom, type Type you just enter 0 ########## (remove spaces). So your phone number will display seamlessly: