| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change dates input as 20080426 to date format in Excel?
We have data downloaded to Excel from our AS400 server.
However the date format is YYYYMMDD without slashes to separate. Therefore, Excel does not recognize this as a date format and is unable to perform calculations properly. I'm looking for a formula or process that will make this recognized as a date format in Excel so dates can be compared. We are currently using Microsoft Office Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| how to change format of several dates entered in an Excel column | New Users to Excel | |||
| access dates in excel, how to change format? | Excel Discussion (Misc queries) | |||
| Why does Excel change the dates I input? | Excel Worksheet Functions | |||
| How do I change the format of a cell based on what I input? | Excel Worksheet Functions | |||
Threaded Mode
