How change Excel default date format to something useful

G

Guest

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).
 
G

Gord Dibben

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


Gord Dibben Excel MVP
 

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

Default Date Format 1
date format - excluding year 2
Date Format 3
Excel default date format 1
How to change default date formula on Excel worksheet 2
Wrong date format in header 1
Excel date formats 2
Excel How to change the "Short Date" format in Excel? 4

Top