Archive for June, 2011

Excel/Windows: Change default date display format

By default, the “short date” display format for Windows (and thus Excel) is “M/d/yyyy.” For example, June 1, 2011 would be displayed as 6/1/2011. For varying reasons, you may want to zero-fill your dates and have June 1, 2011 read as 06/01/2011. Doing this actually involves a Windows setting, not an Excel setting. So, be prepared to have your dates displayed accordingly across the whole operating system and many other programs.

To change the default date format in Windows:

  1. Go to Start –> Control Panel and select “Regional Settings” or “Region and Language,” depending on your operating system.
  2. In the Short date format list, select the desired format:
    SS-2011.06.01-20.29.12
  3. Click OK.

Now, unless the dates in Excel were formatted using the format menu, they should now display as you’ve defined them.

16 Comments

%d bloggers like this: