Converting a non recognizable date time
 

I have high speed monitoring equipment that imports thousands of date time
readings as follows:
05/24/2010 14:20:00.000.084

Excel does not recognize it as a date time and I only need:
05/24/2010 14:20:00

Is there a way to convert the unrecognizable date time to a usable date time?

Converting a non recognizable date time
 

Hi,

have a look at 'Data|Text to columns' and use the full stop as the delimeter



--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mlman" wrote:

I have high speed monitoring equipment that imports thousands of date time
readings as follows:
05/24/2010 14:20:00.000.084

Excel does not recognize it as a date time and I only need:
05/24/2010 14:20:00

Is there a way to convert the unrecognizable date time to a usable date time?