Excel Tip: Change Default Date Style | AccountingWEB

Excel Tip: Change Default Date Style

You may try to enter September 22, 2000 as 9/22/00, but Excel has other ideas about how the date should be displayed. Whether you prefer the style of 22.9.00, 9/22/2000, 9-22, or something completely different, you can leave specific instructions for how your dates should appear.

The style that Excel uses to display your date is actually controlled outside of Excel, in the Windows Control Panel.

Follow these steps to customize the default date style to your liking:

  1. Click the Start button on your Taskbar and choose Settings, Control Panel.

  2. Double-click on the Regional Settings icon, and the Regional Settings Properties window will appear.

  3. Click the Date tab, and you will see an indicator for Short date style. This is where Excel is getting its standard setting for displaying the date.

  4. Choose from several short date styles available in the drop-down list. If the style you prefer is not on the list, choose a style that is close to what you want, then make any changes you want. For example, you can make a two-digit year into four digits by changing the "yy" to "yyyy" or you can substitute dashes or periods for the slashes that separate the month from the day and year.

  5. While here, you can customize the Long date style in the same manner.

  6. Click OK when you have finished entering your preferred date style(s).
Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

WHAT KIND OF FIRM ARE YOU?
As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.