0 How to keep leading zeros in Excel
excel don't hide leading 0

If you want to keep the leading zeros in Excel, you just need to format the cells as Text formating befor you typing the data.
1. Select the range cells you want to type the data with leading zeros into, and right clcik to select Format Cells from the context menu. See screenshot:





2. In the Format Cells dialog, click Number tab, and select Text from the Category pane. Click OK to close the dialog. See screenshot:




Now when you type numbers with leading zeros into the range cells, the leading zeros will be retained in the cells. See screenshot:





Note: This method cannot work if you format cells as text after typing numbers.


selection

format cell text text

0 .