Default Date Format

S

shep

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
 
D

David McRitchie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
default date format 5
Date Format - simple question 1
Dlookup 7
Formatting 0
Change date format in Excel footer 2
Week starts on Friday 3
Default date format 1

Top