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 .