You don't need to any function, just follow these steps:
Step 1:
Select the cell or the range of cells that contain the dates to be changed.
Step 2:
Press Ctrl+1 and select Custom from Category list box.
Step 3:
In Type text box put this format:
m/d/yyyy h:mm:ss
Step 4:
Hit OK.
