| 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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date problem YYYYMMDD
If you use the following macro
Code:
Sub ReopenFile() fileName = Application.ActiveWorkbook.FullName Application.ActiveWorkbook.Close Application.Workbooks.Open Filename:=fileName End Sub this will help... Original idea from http://forum.foxclub.ru/read.php?29,326842,page=2 "Hilco van Olst" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
