Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date
I am importing data from an AS400 program and my dates are formated as 10107
for January 1, and would be 110107 for November 1. Can anyone help me figure out out to convert to 1/01/07 and 11/01/07? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you convert a number into a date | Excel Worksheet Functions | |||
Convert number to date | Excel Discussion (Misc queries) | |||
Convert Date to number? | Excel Worksheet Functions | |||
How can I convert a date into a week number... | Excel Worksheet Functions | |||
How do I convert Date serial number to date | Excel Worksheet Functions |