Follow the steps to change a date without losing formatting:
Select and copy the date cells.
Paste the text into Notepad.
Return to Excel and select the cells to paste the dates.
In the Home tab, go to Number and choose the Text format from the drop-down menu.