Converting a number to a date/time

[den748]

I need to make a program that turns a number in the form of ymmdd int
yy/mm/dd. I also have time in the format of hhmmss and need it in th
form hh:mm:ss. I have tried various things in excel but was not abl
to figure out how to convert it. Please help me. Here are som
example numbers,

40106 (ymmdd)
145625 (hhmmss)

Thank yo

 

[Bob Phillips]

Take a look at Chip Pearson's page
http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)