The Number tab of the Format Cells dialog box. Excel displays the Format Cells dialog box.
2 Select the cell in Excel that you want to paste into. For instance, you may have a chart of accounts in which general ledger account numbers start with leading zeroes. Select all of the text you want to copy to Excel and copy it to your clipboard.
PASTE LIST INTO EXCEL ZIP
The first example that comes to mind is ZIP Codes, in which some have leading zeroes.