Hi again,

Am Wed, 25 Sep 2013 20:37:40 +0200 schrieb Claus Busch:

I get an excel sheet mailed to me that shows an
event time. i.e. "9/24/2013 4:10:00 PM". As received, the custom format
now is "mm/dd/yyyy hh:mm:ss AM/PM"

or first format your column custom as mm/dd/yyyy h:mm:ss and then run
TextToColumns


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2