| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date problem YYYYMMDD
We have a problem with excel 2007 NL ;
a date format used as YYYYMMDD is treated as a date format as YYYYDDMM. When i import a file with a date : 20080405, this is treated as 4th of may 2008 (this should be : 5th of april 2008) The date 20080513 gives an error If I'm trying the same in Excel 2000 or Excel 2003, the date is treated the right way. I'm using : Windows server 2003 X64 as a terminal server, with Office 2007 standard NL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in the form of yyyymmdd | New Users to Excel | |||
| Formatting a date as yyyymmdd + ## | Excel Worksheet Functions | |||
| convert date (YYYYMMDD) to weeknumber | Excel Worksheet Functions | |||
| I need a yyyymmdd date format with no dashes | Excel Discussion (Misc queries) | |||
| Is there an Excel date format as follows: yyyymmdd? | Excel Discussion (Misc queries) | |||
Threaded Mode
