- Hot Topics
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 5, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel