Prev: Conditional Format - How to View???
Next: Convert to negative numbers in whole worksheet
From: mlman on 27 May 2010 16:40
Thanks for your help!

"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?
 | 
Pages: 1
Prev: Conditional Format - How to View???
Next: Convert to negative numbers in whole worksheet