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.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.