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
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