Format numbers to keep leading zeros in Excel
  1. Select the cells on your worksheet where you'll be adding the data.
  2. 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.