Date Problem with Excel 2003 & 2007

June 9, 2009 at 16:08:00
Specs: Windows XP
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.


See More: Date Problem with Excel 2003 & 2007

Report •


#1
June 9, 2009 at 17:50:51
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.


Report •

#2
June 9, 2009 at 21:05:15
Thank you so much! That worked great!

Report •

Related Solutions


Ask Question