Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 date format bug?
I have a problem with dates
Dates with day 12 are reproduced in text format, but otherwise correct, days <=12 as MM/dd/yyyy. My pc is set to UK short date format dd/MM/yyyy etc. in Control Panel. (An external app creates the data, and it was OK with office98). I saw a Microsoft note that says this is a problem when using VBA and Excel 2000/2002, and it describes this problem exactly. I can't see a note on Excel/Office 2003. Does anyone know if same bug is present?... and if so, is there an SP update/hotfix for it? thanks chris |
#3
|
|||
|
|||
I used to have problems as you described, especially operating between Excel 97 and Excel 2000 and 2003 on Windows 2000 and XP. One thing I did notice that helped me was that Excel 97 set the column format from the first date in the column, if it was 13/01/04 all was ok, if it was 12/01/04 the problem you describe appeared. (I use dd/mm/yy) With Excel 2000 and later, when you import data you can select the form of date to be used for the whole column, (on the third import screen), which was MOST useful. Once the date is set as 'text' and dates (displayed on the left and right side of the column) it was difficult to correct. Was your data imported, and can you select the date format for the column? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=384980 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Excel 2003 is changing my date formats | Excel Worksheet Functions | |||
Excel Date Format - Stop? | Excel Worksheet Functions |