novice0902

Clarification of Jan 1 1904 Reference Spacesurfer, You wrote in your post: No, no!! 19.04.01 is not Jan 1 1904. It is just a coincidence that my example date (dd.mm.yy) of 19.04.01 is roughly like Jan 1 1904. When I mentioned Jan 1 1904 I was not referring to my example date. - Novice

Excel 2003 "1905 Date Problem" Solved jaclaz. In your post of 20 Oct you said : A "square" is how Excel usually represents some ASCII unprintable characters. Maybe you have some strange setting in "International". I decided to check Win XP >control panel >regional and language options > customise > date > date separator. There was an invalid character in the date separator box instead of the blank I thought was there. The invalid character was invisible but Win XP told me it was there when I tried to close the date tab. I then deleted this invalid character and inserted a blank which is my preferred date separator. This has solved the 1905 date problem in my Excel 2003 worksheet. Thanks for your help. - Novice

jaclaz, Thanks for the advice. I will try it out and report back. This "1905 problem" seems to be related to a particular computer. When I take any Excel 2003 worksheet that is affected by the 1905 problem on this particular computer and edit it on other computers then the 1905 problem is absent. I believe 1 Jan 1900 and and 1 Jan 1904 have special significance in Win XP and MS Applications as start dates for counting days but I have never heard of any similar significance for 1905. I can't relate this particular year to anything I know of in MS software and can't guess why 1905 pops up. - Novice

20 Oct 2009 Excel 2003 Date Problem – Edit a date and the year changes to 1905 My copy of Excel 2003 has developed a problem with dates. Reinstalls of Win XP and Office 2003 have not fixed the problem except temporarily. I do the following: 1. Open Excel 2003 and enter 37000 (for example) in a cell. 2. Format > cells > date, and choose the dd.mm.yy format. 3. This converts the 37000 in the cell to 19.04.01. At this point there is the first sign of trouble. The date is displayed in the format yyyymmdd in the formula bar but empty squares appear between the dd,mm, yyyy parts of the date. These empty squares are not blanks but actual squares. When I see them I know the problem is back even before I edit a date.The usual date separators such as slashes or dots are absent. If I then change any part of the date the whole date will change to a date in 1905. For example, if I change the 04 to 05 in 19.04.01 the whole date changes to 23.06.05. Whatever the change, the resulting year is always 1905 but the resulting dd and mm are not always the same although dd = 23 and mm = 06 are most frequent. The choice of date format in step two above makes no difference to the problem. Any help with this weird problem would be appreciated. - Novice

20 Oct 2009 Can Word 2003 Toolbar Customisations be Saved? I use Word 2003 and I like to customise my default template (i.e. normal.dot). When I replace normal.dot with a customised version I lose my customisations of Word 2003 toolbars and have to re-customise them. Is there a way to save Word 2003 toolbar customisations and restore them after a change of normal.dot? - Novice