| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How change Excel default date format to something useful
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). |
|
#2
|
|||
|
|||
|
StartSettingsControl PanelLanguage 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 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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
| date type format which is supported by excel 2003 | Charts and Charting in Excel | |||
| how do i set a default date format in Excel | Excel Discussion (Misc queries) | |||
| How do I change the default number format in Excel? | Excel Discussion (Misc queries) | |||
| How do I change the default number format in excel? | Excel Worksheet Functions | |||
Hybrid Mode
