Default date format

  • Thread starter Thread starter gschimek
  • Start date Start date
G

gschimek

Is there a way to change the default date format in excel 2002 to onl
use 2 digit years. I've looked through the options and don't se
anything.

Example:

default: mm/dd/yyyy
desired: mm/dd/yy

Thanks in advanc
 
Go to <format><custom> and enter in the "type" box what you require
Regards
Bill K
 
Change the Windows Regional and Language settings for "short date"

Start>Settings>Control Panel>Regional and Language Options>Regional
Options>Customize>Date.

NOTE: this is a global change and will affect all programs running under
Windows.

Gord Dibben Excel MVP
 
Back
Top