Thank you so much for this! It (almost) does everything I need.
It works perfectly on the time column, but with the date not quite.
What is will do is convert a date serial number to the correct date (eg
if the number is 1 it will convert it to 1 Jan 1900). However the dates
in the reference number are not serial numbers.
ie. 140704 is 14/07/04.
Any ideas how to work around this?
Thanks again.
sd
--
systematic
------------------------------------------------------------------------
systematic's Profile:
http://www.excelforum.com/member.php...o&userid=25294
View this thread:
http://www.excelforum.com/showthread...hreadid=491029