Converting a number to a date/time
 

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

--
Message posted from http://www.ExcelForum.com

Converting a number to a date/time
 

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)

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

40106 (ymmdd)
145625 (hhmmss)

Thank you


---
Message posted from http://www.ExcelForum.com/