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

How to Set Regional Dates in Excel 2013

Click the Date tab in the Customize Format dialog box. Click the Short Date format and then type D/m/yyyy, the new date format.

You have to type this European date format because the United States regional settings don’t automatically include this format in the Short Date Style drop-down list. After manually entering this format, the European date format becomes part of the list that you can then select from in the future.

  • 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 Share Excel 2013 Files
Create Charts in Excel 2013 via the Quick Analysis Tool
How to Add Comments to Excel 2013 Worksheet Cells
How to Describe a Custom Excel 2013 Function
Advertisement

Inside Dummies.com