Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
Create Charts in Excel 2013 via the Quick Analysis Tool
Top 10 New Features in Excel 2013
How to Copy Custom Styles in Excel 2013

How to Set Regional Dates in Excel 2013

Step 6 of 6
Next Slideshow
Next Slideshow

Click OK twice, once to close the Customize Format dialog box and then a second time to close the Region or Regional and Language Options dialog box.

Click the Close button in the upper-right corner of the Control Panel window or press Alt+F4 to close this window.

After changing the Short Date format in the Windows Control Panel, the next time you launch Excel 2013 it automatically interprets short dates using the D/m/yyyy format; so that, for example, 3/5/14 is May 3, 2014, rather than March 5, 2014.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Move Pivot Charts in Excel 2013
How to Add Comments to Excel 2013 Worksheet Cells
How to Select Cells in Excel 2013
How to Find the Excel 2013 Formatting Toolbar Buttons Equivalents
How to Share Excel 2013 Files
Advertisement