Format numbers to keep leading zeros in Excel
- Select the cells on your worksheet where you'll be adding the data.
- Right-click anywhere in the highlighted cells. Then on the shortcut menu, click Format Cells> Number Format>Text >OK.
3. Type or paste the numbers in the formatted cells.