

Using an apostrophe before inserting numbers in an Excel cell is the quickest way to apply the Text format. Use Apostrophe to Keep the Leading Zeros of a Phone Number in Excel Read More: How to Custom Cell Format Number with Text in Excel (4 Ways)Ģ. This is how you can retain the leading zero of a phone number or any kind of number in Excel. This time Excel won’t remove the 0 from the front side and will keep all the numbers like this:

So, all the cells in your selected area are now under the Text format.Īfter that, you can insert any kind of number with a leading zero. From the Number group, select the Text format.Highlight all the cells where you want to keep the numbers with a leading zero.To keep that leading zero of phone numbers, follow the process below: So you might face problems while inserting phone numbers in your Excel worksheet. When you insert a number with leading zeros in a cell, Excel automatically removes that zero. Apply Text Format to Retain 0 Before a Phone Number in Excel This is how you can retain the leading zeros too.Ħ Methods to Keep 0 (Zero) Before a Phone Number in Excel 1. Excel will automatically insert two leading zeros to make it 7 digits in total. For example, you have set a cell to display 7 digits in total. You can set the cell format in such a way that it always displays a certain number of digits.Put an apostrophe (‘) in front of the numbers. This will prevent Excel from removing the leading zeros. There are two possible ways that you can follow to retain the leading zeros in Excel. It only keeps the digits that make sense. So, when you insert numbers with leading zeros in an Excel worksheet, Excel automatically removes them from a cell. This happens because any number of zeros, before real numbers, is meaningless. For example, if you insert 007 in a cell in Excel, you will see only 7 is there.

When you insert numbers in an Excel worksheet having leading zeros, Excel automatically removes all of them.

Keep the Leading Zero of a Phone Number.xlsx
