I'm not sure if using slashes will allow for varying regional
interpretations of month/day ordering in that format; but, given the
international date ordering inside the original text, using dashes can never
be misinterpreted (plus it saves two characters)...

=--TEXT(LEFT(A1,14),"0000-00-00 00\:00\:00")

--
Rick (MVP - Excel)


"Dave Peterson" wrote in message
...
I could use a helper cell with a formula like:

=--TEXT(LEFT(A1,14),"0000\/00\/00 00\:00\:00")

And give it a number format of:
mm/dd/yyyy h:mm:ss AM/PM



PowerUserInTraining wrote:

I have system generated file that I work with regularly that provides
date
and time
information like this: 20080919021412.000000-240

I'm having difficulty converting that field to show the following
date/time
format:
9/19/08 2:14:12 AM

Any suggestions?

--

Dave Peterson