Hello,

Does anyone know how I could take a date like this..

30/05/2006 9:33:03 AM

split it up and store the first part of it in variables. So 30 would be
stored in a variable of its own, 05 would be stored in a variable of its
own and 2006 would be stored in a variable of its own.

Thanks


--
snowing
------------------------------------------------------------------------
snowing's Profile: http://www.excelforum.com/member.php...o&userid=34576
View this thread: http://www.excelforum.com/showthread...hreadid=558237