Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Date Problem with Excel 2003 & 2007

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Date Problem with Excel 2003 & 2007

Reply to Message Icon

Name: dkoehn
Date: June 9, 2009 at 16:08:00 Pacific
OS: Windows XP
Subcategory: Microsoft Office
Comment:

Help! Is there a way to change the default date format from mm/dd/yyyy to mm/dd/yy on ALL spreadsheets opened in Excel?

I never want to see a 4 digit year again.



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: June 9, 2009 at 17:50:51 Pacific
Reply:

It's not an Excel setting, it's an OS setting.

I can only speak for XP Home...

Control Panel...Regional and Language Settings

Click the Customize button then the Date tab

Change the Short Date from yyyy to yy.

You can change the Long Date also, but that might look a little weird.


0

Response Number 2
Name: dkoehn
Date: June 9, 2009 at 21:05:15 Pacific
Reply:

Thank you so much! That worked great!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Outlook 2003 SP3 not rece... Recovery manager and re-i...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Date Problem with Excel 2003 & 2007
Problems with Excel Formulas www.computing.net/answers/office/problems-with-excel-formulas/5502.html

Problem with Word 2003 www.computing.net/answers/office/problem-with-word-2003/4903.html

Excel 2003 doesn't open the file www.computing.net/answers/office/excel-2003-doesnt-open-the-file/5695.html