If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default Date Format
Using Office 2003 Pro
Is there a way to set default date format to medium; i.e, 12-Nov-05? I have Win Regional set to dd-mmm-yy, but Excel defaults to short date such as 12-11-05. Thanks |
#2
|
|||
|
|||
Default Date Format
There is no separate setting for Excel -- it uses your Regional Short Date
system setting. But since you are having a problem with mixed dates, you might want to consider changing your format to yyyy-mm-dd which is the ISO standard. A couple of things that you should be aware of is that VBA is US centric (mm/dd/yy) so dates will be treated in the US format. If you want to enter a specific date in VBA it is safest to use the DATE function. and Excel (not VBA) is "kind" enough to make a bad date become a good date, so if there aren't 31 months in a year Excel will assume that was days (or years) and change the date to a valid one -- with dates like 11/12/05 and 12/11/05 Excel will use your Regional settings in the order you specified. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "shep" wrote in message ... Using Office 2003 Pro Is there a way to set default date format to medium; i.e, 12-Nov-05? I have Win Regional set to dd-mmm-yy, but Excel defaults to short date such as 12-11-05. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook today should show tasks based on Start Date, not due date | Rose | General Discussion | 10 | October 9th, 2005 03:14 AM |
Setting default headers and fonts in a template | officequestions | General Discussion | 5 | August 31st, 2005 01:54 PM |
Default date format ? | GaryDennis | Using Forms | 6 | June 20th, 2005 09:14 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
DCount and Date format Question Against IBM DB2 Date | RNUSZ@OKDPS | Running & Setting Up Queries | 2 | March 7th, 2005 09:19 PM |