| 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?
A bit late to this thread...but...
try this: B1: =--TEXT(A1,"0000-00-00") (format B1 as a date) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Judy CS" <Judy wrote in message ... 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. |
| Reply |
| 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 | |||
Hybrid Mode
