Question: how to copy and paste in excel with leading zeros?
Answer: Select the cells that will hold the data you are going to paste.
Choose the Cells option from the Format menu. Excel displays the Format Cells dialog box.
Make sure the Number tab is selected. (See Figure 1.)
In the Category list, choose Text.
Click on OK.