Hi everyone,

I'm a little stuck and desperate for advice! My brain has turned to
mush so now I turn you all for help. :)

I have a reference number in a receipting system. eg jd1407051455

The number is made up of two letters (initals of person), date (ddmmyy)
and 24 hour time (hhmm). Using VBA I have managed to split the number up
so that each piece of information sits in it's own column. (ie Column A
= name, B = date, C = time). This was done by copying, pasting and then
deleting irrelevant characters.

I now need to use VBA to insert the seperators so that excel recognises
these numbers as dates and times respectively.

eg. Instead of 140705 in a cell, I need 14/07/05 and instead of 1455 I
need 14:55.

I am at a complete loss as to how this can work. Just to throw a
spanner in the works - I need to somehow make it work on a complete
range (up to 1,000 rows of data) not just single cells.

If anyone has any ideas...I will be eternally grateful!

Thank you

sd


--
systematic
------------------------------------------------------------------------
systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294
View this thread: http://www.excelforum.com/showthread...hreadid=491029