To format excel numbers with leading zeros Select cells in which numbers with leading zeros will be entered.
![Select the cells you would like to change Select the cells you would like to change](https://howtech.tv/wp-content/images/001746/01.jpg)
Click on Format in the Menu
![Click format Click format](https://howtech.tv/wp-content/images/001746/02.jpg)
Select Cells
![Select Cells Select Cells](https://howtech.tv/wp-content/images/001746/03.jpg)
For the cell type choose custom.
![Choose custom on the left Choose custom on the left](https://howtech.tv/wp-content/images/001746/04.jpg)
Now enter in the amount of leading zeros you want plus the number sign.
![Add leading zeros plus a # sign Add leading zeros plus a # sign](https://howtech.tv/wp-content/images/001746/05.jpg)
Click ok.
![Click ok Click ok](https://howtech.tv/wp-content/images/001746/06.jpg)
Leading zeros will now be added to your number.
![Leading zeros will now be in front of all of your cells Leading zeros will now be in front of all of your cells](https://howtech.tv/wp-content/images/001746/07.jpg)