How change Excel default date format to something useful

's Computer Specifications

I use Excel 2003 and the default date display is dd-mmm; no year (ex;
23-Mar; a European format (?) that is not useful for people in the US or at
least to me at all). How do I change the default format to dispay year (2
digit) or any year information. All Excel default date help only gives
information on defaults that are not displayed with Excel 2003 (i.e., not
useful).

's Computer Specifications

Start>Settings>Control Panel>Language and Regional Settings is where Excel
gets its short date format from.

Gord Dibben Excel MVP

On Mon, 26 Sep 2005 11:22:03 -0700, mjk <(E-Mail Removed)> wrote:

>
>
>I use Excel 2003 and the default date display is dd-mmm; no year (ex;
>23-Mar; a European format (?) that is not useful for people in the US or at
>least to me at all). How do I change the default format to dispay year (2
>digit) or any year information. All Excel default date help only gives
>information on defaults that are not displayed with Excel 2003 (i.e., not
>useful).

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change the default header date format in Excel 2007?	Jazzman721	Microsoft Excel Worksheet Functions	3	12th Jun 2009 10:35 PM
How to change the default format for date?	=?Utf-8?B?RXJpYw==?=	Microsoft Excel Misc	3	29th Sep 2007 03:51 PM
Change Default Date Format	Alan Z. Scharf	Microsoft Excel Discussion	0	24th Apr 2007 10:02 PM
How do I change the default date format in an Excel Footer	=?Utf-8?B?QnVya2k=?=	Microsoft Excel Setup	1	4th Feb 2005 02:15 AM
How to change default date format of dd-mmm?	Ken B.	Microsoft Excel Misc	2	15th Jul 2003 05:07 PM