| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert int ccyymmdd to date(time)
Hi, our legacy system keeps dates in integers in form ccyymmdd.
I've long known how to convert, in Excel, a datetime to a number. One example is: =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2)) But looks as I may, I haven't found a way to convert a ccyymmdd int into a datetime. Oh also, I'm using Office 2007. The FORMAT function, which might (?) have helped me, seems to have disappeared. thanx - pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date/time to time only in Excel? | Excel Discussion (Misc queries) | |||
| Can Excel (2003) reverse date from ccyymmdd to mmddccyy? | Excel Discussion (Misc queries) | |||
| convert second to date and time | Excel Worksheet Functions | |||
| How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? | Excel Worksheet Functions | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
Threaded Mode
