In a CSV file I have data in this format
24/12/2010 7:24:56 AM
in older versions of excel just opening the file it recognizes it as time.
In 2007 it doesn't....and I'm not quite sure how to get Excel to recognize it as a date time.
Use Data|Text-to-Columns to parse the date as DMY:
This will parse the date into American date and time, but in separate columns. To put them back into a single column, create a formula in the column next to the time column, adding the two together. For example, if your dates start in A1 and your times start in B1, in C1, just enter
=A1+B1 and copy that down for the rest of your date values.
In some cases, you can also multiply the value by one to force Excel translate a text into a number (when possible).
A1 = 24/12/2010 7:24:56 AM B1 = A1 * 1
Hope it helps.