Try this:

=date(left(a1,4),mid(a1,5,2),mid(a1,7,2))+time(mid (a1,9,2),mid(a1,11,2),mid(a1,13,2))

Regards,
Fred.

"PowerUserInTraining" wrote
in message ...
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?