Question: how to copy and paste dates in excel without changing the format?
Answer: Select the cells whose contents you want to copy. Press Ctrl+C to copy them to the Clipboard. Select the cell where you want to paste the contents. Choose Paste Special from the Edit menu. ...  Make sure the Formulas radio button is selected. Click on OK.