Excel: Changing incorrect Dates to all look the same


I have recieved a large amount of data to scrub, half of the dates were inputted incorrectly. When I go to format cell and change the date format no change is made as excel does not view it as a date. The way the date is displayed is below. (The zero before the month is what I believe is throwing everything off). Looking for a quick way to get the date to go from looking like this 20/02/2014 7:00:00 to a date that looks like this 20/2/2014 7:00:00 AM


This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of May 05, 2014.


For more resources for Microsoft Excel