Home |
Search |
Today's Posts |
#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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Date Format - Conversion | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Australian date format in Excel 2000 | Excel Discussion (Misc queries) |