Changing Your System Date Settings

Changing your operating system’s regional settings — whether it’s a PC or Mac — allows you to see and enter dates in a way that is familiar to you. In Excel, for instance, entering dates will be different based on the regional settings.

To change the way date information is displayed on Apple’s Mac OS X:

  1. Click the Apple menu icon for apple menu, then choose SYSTEM PREFERENCES.
  2. Select the LANGUAGE AND TEXT control panel, [Click] the FORMATS tab.
  3. In the REGION pop-up, choose a region that corresponds with the date format you want.

To change the way date information is displayed on your Windows system:

  1. [Click] icon for windows start menui, CONTROL PANEL, then choose REGION AND LANGUAGE .
  2. On the FORMATS tab, specify a FORMAT, or select specific options from DATE AND TIME FORMATS. See EXAMPLES for a preview of the changes.
  3. [Click] OK.

Windows also offers you the opportunity to change how two digit years are interpreted as well.

To change how a two digit date is interpreted on your Windows system:

  1. Repeat step 1 from above.
  2. On the FORMATS tab, [Click] ADDITIONAL SETTINGS, then select the DATE tab.
  3. Under CALENDAR, set WHEN A TWO DIGIT YEAR IS ENTERED, INTERPRET IT AS A YEAR BETWEEN to the desired range.
  4. [Click] OK, OK.
Previous article A First Date with Excel: Entering Dates