Select the range of cells that will contain numbers with leading zeros. Right click the group and select “Format Cells”. Choose the Number tab. Select “Text” from the list of categories. Now, the information entered into the cells will be treated as plain text, and will appear exactly as entered.