May not translate in an exchange of workbooks (?). Incorrect use results in a #VALUE! error. US like =TEXT(A1,':mm') might be =TEXT(A1,'[TT}:mm') in another language, The long date format in Regional settings is used by Excel for the Headingsĭifferences in Regional Settings may not be immediate apparent. The short date format in Regional settings is used by Excel for the General format. The same letter combinationsĪre used in Regional Settings as seen in Excel Help In Excel under Format -> cells -> Custom -> mm/dd/yyyy Will keep track of dates but it may not be what you see displayed or you may not be sure.Ĭhange your Regional Settings (shown with US values month/day/year) If you do not do this you may not be able to distinguish which part of the date is the year, the month, day and have furtherĭifficulty knowing whether you actually have a 19xx year or a 20xx year. Suggest you make changes such as the following so that all of your dates willĭisplay as four digit years.
There is enough confusion between US and UK dates without dealing with 2-digit years. Yahoo! - This Day in History Something you should have changed before 2000 (#y2k) Microsoft Virtual Machine is no longer supported, you should install JAVA to run JAVA applets.] [An example of a countdown timer for date was removed from this area that relied on Microsoft Virtual Machine,
